Pivot Chart Expression using RowNo()

[#1]

Can some please take a look at my second Pivot Chart and help me understand why I am getting value only for 1 value of the dimension?

[Anil_Babu_Samineni]

This is you are expecting to see?

[#3]

Hi Anil,

No! my expectation is to see value for each row and column intersection. Similar to what I have in Pivot 1

Thanks for your help.

[rubenmarin]

Hi, the $-expansion is done before the table is calculated, so the RowNo() in set analysis won't work as expected, it returns '1' (for all rows), so only sums v1.

Something as this can work but with this sample, I don't know if it's suitable in real data:

pick(RowNo(),

sum(total{<Venue={'v1'}>} Value),

sum(total{<Venue={'v2'}>} Value),

sum(total{<Venue={'v3'}>} Value),

sum(total{<Venue={'v4'}>} Value)

) + pick(ColumnNo(), // or should be '*' or any other operation?

sum(total{<Venue={'v1'}>} Value),

sum(total{<Venue={'v2'}>} Value),

sum(total{<Venue={'v3'}>} Value),

sum(total{<Venue={'v4'}>} Value)

)