Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculations in piviot tables
I am pulling data from analysis services into a piviot table. Is there a way
withing the pivot table to add a calculation please? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculations in piviot tables
Here is some starter information
http://www.contextures.com/xlPivot10.html If you need something more complex, click on the pivot table toolbar, then Formulas calculated field. You can do more complicated things there. Play around with that a bit and I am sure you will get what you need. -- Allllen "sansimeon" wrote: I am pulling data from analysis services into a piviot table. Is there a way withing the pivot table to add a calculation please? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculations in piviot tables
Hi
In addition to Allllen's suggestion, it can sometimes be difficult to achieve just what you want with calculated fields or calculated items inside the PT. If this is the case, then an additional column in the source data to carry out your calculation, and then including the new column in the range for the PT can provide the answer. -- Regards Roger Govier "Allllen" wrote in message ... Here is some starter information http://www.contextures.com/xlPivot10.html If you need something more complex, click on the pivot table toolbar, then Formulas calculated field. You can do more complicated things there. Play around with that a bit and I am sure you will get what you need. -- Allllen "sansimeon" wrote: I am pulling data from analysis services into a piviot table. Is there a way withing the pivot table to add a calculation please? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculations in piviot tables
Thank you. I have added calculated members to my OPAP cube and associated
these with the dimension I am using for the row layout. All looks ok in the cube yet in the pivot table I can only see the calculated members when I use this dimension for a report filter as soon as I use it for a row or column layout it disappears. "Allllen" wrote: Here is some starter information http://www.contextures.com/xlPivot10.html If you need something more complex, click on the pivot table toolbar, then Formulas calculated field. You can do more complicated things there. Play around with that a bit and I am sure you will get what you need. -- Allllen "sansimeon" wrote: I am pulling data from analysis services into a piviot table. Is there a way withing the pivot table to add a calculation please? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculations in pivot tables | Excel Discussion (Misc queries) | |||
Change selected field in all piviot tables | Excel Worksheet Functions | |||
How to pull numbers from two tables with conditions? | Excel Worksheet Functions | |||
Macro for Pivot Tables | Excel Discussion (Misc queries) | |||
Calculations using totals generated in Pivot Tables | Excel Discussion (Misc queries) |