Automatic calculation in Pivot Table

Hi, I am completely new to this BI thing. I have watched (and re-watched) several hours of recorded Webmeeting tutorials yet obviously missed a lot. I am using Sage Peachtree for Manufacturing 2012 with BI. How can I get a cell to calculate a commission from a sum of tonnage column from my pivot table? I would like for the cell to be located underneath the pivot table, yet depending upon the month I parameter the pivot table sum is never in the same row. I would like for the calculation cell along with the label of that cell to automatically locate under the pivot table no matter how long or short the table is for that given month. This is getting long, but I also would like to know if I can make said single cell calculate total commissions with different multipliers for tonnage from certain customers within the same "sum of tonnage" column?

 Thanks, Joe

Views: 68

▶ Reply to This

Replies to This Discussion

Permalink Reply by Ruth Gray on November 2, 2011 at 10:06pm

Hi Joe

Have you perhaps got a sample report in Excel that you can share? It would help to see what you are trying to do? And where you are wanting this calculated cell. Any reason why you need to have the cell underneath the PivotTable?

Thank you Ruth

Permalink Reply by Joe Orwig on November 3, 2011 at 12:24am

Ruth,

Thanks for replying. I can try to attach a sample but it will have to wait till tomorrow when I get back into the office. I do not suppose it "has" to be underneath, that is just the way (where) I've been manually calculating and reporting it for years. This BI report will be much different than what the salespeople are used to but much less time consuming for me to generate (hopefully). I'll post again AM.

Joe

Permalink Reply by Joe Orwig on November 3, 2011 at 3:46pm

I uploaded (I think) an example of what I'm talking about. I moved the calculation cells (highlighted green) to above the tables which should eliminate any longer tables overlapping it. (Good idea Ruth) But I still need assistance with how to make the calculation cells (E2, E3 & E4) to automatically find specific sums even when columns report more or fewer lines. E2 needs to find the total sum of table one column B, E3 needs to find the subtotal of a specific customer in column E, and E4 needs to find the total of column E. I have the cells manually keyed into the correct sums on this sample but if I'd run August's report the sums would be in different cells. Is there any Hope?

Thanks Joe

Attachments:

RSS

Follow Alchemex on twitter

Like Alchemex on facebook

This Weeks Top Content 

1 Problem - Grouping by Custom Account Groups

Problem - Grouping by Custom Account Groups
2 Picklist for Accpac SQL databases

Picklist for Accpac SQL databases
3 Possible to Rename DB name in Pervasive SQL DB Name Manager?

Possible to Rename DB name in Pervasive SQL DB Name Manager?
4 ODBC Driver selection when entering data connection details

ODBC Driver selection when entering data connection details
5 Combining Accounts in SMI financials

Combining Accounts in SMI financials

Alchemex Integrates with:


© 2012   Created by Admin.

Badges  |  Report an Issue  |  Terms of Service

Sign in to chat!