Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
Use Dimensionality() function in expression level below way.
if(Dimensionality()=1, exp1,if(Dimensionality()=1, exp2....)), final exp)
You will need to point out what is the exact result you are hoping to get?