Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have one question about how to minus ColumnNo() in my following expression:
If(RowNo() = 3,
If(ColumnNo() < $(CurrentMonth),
Sum([BP.Value])
,Text(Above( Sum( [BP.Value] )) - Sum( [BP.Value]))&'/'&
Text(ONLY({<BestWorst.Month = {"$(=CurrentMonth * 2 - 1)"}, [BestWorst.Year] = {"$(=Best)"}>}BestWorst.Value))
&'/'&Text(ColumnNo())
),Sum([BP.Value]))
I have tried: {<BestWorst.Month = {"$(=CurrentMonth * 2 - 1 - ColumnNo())"} but it doesn't work...
Please help me, thanks!
ColumnNo() returns the index number of the dimension or expression in a pivot table.
Can you explain in more detail what you're trying to do? An example app would help.