Show total disregarding calculated dimension

[#1]

Hi all,

I need to show the last 15 dimension-values inside a chart-diagram which sums values. Showing the last 15 dimensions-values can be managed through a calculated dimension, but the sum is calculated for this dimension-values only.

However, I need to sum up the total, disregarding the calculated dimension.

Please see the attached screenshot and the QVW as example.

Any ideas?

Thanks,

Eva

[jagan · Accepted solution]

Hi,

Try like this

Dimension: YearWeek

Expression:

=If(RowNo()=1, $(=Sum({<YearWeek={'<= 201420'}>}Value)) ,

Sum({<YearWeek={'>= 201420'}>}Value))

Hope it helps you.

Regards,

Jagan.

[#3]

Hi Jagan,

this is working! Thank you 🙂

Regards,

Eva