Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
May be this
if(SecondaryDimensionality()=4,sum( Amount),
if(SecondaryDimensionality()=3,sum( Amount*_LastMonthQuarterFlag)
,sum( Amount*_LastMonthYearFlag)))
Thanks sunny
i tried 4 th dimesnion its working fine
if user add 5 th or n nof dimensions that expression not working
Based on the number of pivoted dimensions, your expression will have to change every time.
if user add n' of dimensions pivot should show if Year -> Year Last month value
if quarter ->Quarter Last month value
any help that would be a great.