Dimension related issue in Pivot table?

[#1]

i have one report attached Qvw file

in that i created one pivot table

the measure expression like this

See first table in Qvw file

horizontally i add Year,Quarter and Month

by default The table showing Year wise (That means Last month year value )

if user expand one level down the table showing Quarter values( That means Last month Quarter value)

the below expression is working fine for 3 Dimension

now issue with user trying to add more dimensions horizontal Please check second table Qvw file

if user add more dimesnions still i want show only if year _> last month year

if quarter -> last month quaeter.

if(SecondaryDimensionality()=3,sum( Amount),

if(SecondaryDimensionality()=2,sum( Amount*_LastMonthQuarterFlag)

,sum( Amount*_LastMonthYearFlag)))

please help

[sunny_talwar]

May be this

if(SecondaryDimensionality()=4,sum( Amount),

if(SecondaryDimensionality()=3,sum( Amount*_LastMonthQuarterFlag)

,sum( Amount*_LastMonthYearFlag)))

[#3]

Thanks sunny

i tried 4 th dimesnion its working fine

if user add 5 th or  n nof  dimensions that expression not working

[sunny_talwar]

Based on the number of pivoted dimensions, your expression will have to change every time.

[#5]

if user add n' of dimensions pivot should show if Year -> Year Last month value

if quarter ->Quarter Last month value

[#6]

any help that would be a great.