Hi ,
I have a olap cube and building a report .
That uses these calculation
AgroupItems - set of items based on certain condition
BgroupItems - set of items based on certain condition
CGroupItems -set of items based on certain condition
ConsignedItems - set of items based on certain condition
I am doing 4 counts
Count(1 within set [Consigned Items])
Count(1 within set [AgroupItems])
Count(1 within set [BgroupItems])
Count(1 within set [CgroupItems])
Then A% is Count(1 within set [AgroupItems])/Count(1 within set [Consigned Items])
Then B% is Count(1 within set [BgroupItems])/Count(1 within set [Consigned Items])
Then C% is Count(1 within set [CgroupItems])/Count(1 within set [Consigned Items])
so this three data items shows properly in crosstab , but then when i put the data items in a stacked column or column chart , I dont see any values.
Any suggestions on how to trouble shoot is appreciated.
Here my A.B .C are individual percent counts, trying to put in old column chart .
Thanks,