Pivot table issue

[Anonymous]

Hi ,

I created a pivot table with four dimensions and 2 Kpi's.

i can see the correct values, when i expand  all the dimensions at one time.

if i expand dimension by dimension wise, i am not able to see the correct kpi values.

can any one help me.

[vishsaggi]

You have the range for those %spends for individual servedates. Cos for almost every date the condition is satisfied to have 90-100%? Except for 10/27/2013

[sreenivas123]

Use Dimensionality() function in expression level below way.

if(Dimensionality()=1, exp1,if(Dimensionality()=1, exp2....)), final exp)

[sunny_talwar]

You will need to point out what is the exact result you are hoping to get?