Chart Query

[#1]

Hi All

I have a bar chart and have added Total at the last(from dimension limits) and now I was trying to apply bar offset to apply waterfall effect in all bar except the "Total" bar in the end and the first one

I tried the below expression but its now working

if(RowNo()<= Count(DISTINCT [City),RangeSum(Above(Sum(Sales), 1, RowNo())),0)

[MK_QSL]

Sample Apps or Data pls !

[#3]

Hi Manish,

Thanks for help.  I have attached the sample data and chart I want to create .

I have added the formula in bar offset

if(RowNo()<=5,RangeSum(Above(Sum(Sales), 1, RowNo())),0)

I want  5 to be picked dynamically. I tried to use

if(RowNo()<= Count(DISTINCT Country ),RangeSum(Above(Sum(Sales), 1, RowNo())),0)

but its not working

Many thanks for your help and time

[jagan]

Hi,

Try this expression

if(RowNo()<= Count(DISTINCT Country),RangeSum(Above(Sum(Sales), 1, RowNo())),0)

Regards,

Jagan.

[#5]

hi Jagan,

It's not working. I already tried that

[jagan · Accepted solution]

Hi,

Put it in a variable and refer it in the expression.  It is working for me.

Regards,

Jagan.

[jagan]

Hi,

Please find attached file.

Regards,

jagan.

[#8]

Thanks its working fine

[jagan]

HI,

In Variable declaration give = and in expression you can directly use

if(RowNo()<= vtop,RangeSum(Above(Sum(Sales), 1, RowNo())),0)

Refer attachment in previous thread.

Hope this helps you.

Regards,

Jagan.

[rwunderlich]

I think it's preferable to use dimensionality() to test for the total row.

if(Dimensionality()>0,RangeSum(Above(Sum(Sales), 1, RowNo())),0)

-Rob