Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
KPI in pivot table
Hi All,
I'm using Excel 2007 and connecting to an analysis cube. In the cube i have defined a number of KPI's which i'd like to display in an excel pivot table. In the pivot table itself i have set up some filters and dragged on the relevent hierarchies and members. I have also dragged on the status of the KPI. The problem i am having is that it seems to show all entries even if the values making up the KPI are null. This leads to a huge number of red traffic lights attached to NULL data which is skewing my figures. Has anyone else encountered this problem or know of a way that i can resolve this. I'm wondering if i have to change the underlying MDX of the calculation used in the KPI (to which i'm a complete beginner). Any help would be much appreciated. Thanks in advance, Grant |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to create pivot table from existing pivot table in excel 2007 | Excel Discussion (Misc queries) | |||
How do I sort pivot table data outside a pivot table | Excel Worksheet Functions | |||
Pivot table keeps dupping to another linked pivot table | Excel Discussion (Misc queries) | |||
pivot table: create worksheetsheet using pivot table | Excel Discussion (Misc queries) | |||
How do I create a pivot table if the pivot table icon or menu ite. | Charts and Charting in Excel |