add extra bar in bar chart

[#1]

Hi,

I need to add one more bar in start of chart. I have attcahed qvw and final image.

I have formulae for extra bar.

I have already tried total in dimension limit but thats not working

Help is appreciated.

[sunny_talwar]

What is the logic behind that bar?

[sunny_talwar]

If you want to see a total bar, you can do this:

[#4]

I have already tried total, so not working.

l want to put 16 in that bar.

[sunny_talwar]

What does that 16 means my friend? How did you decide that number? Is there a logic behind 16 here? Is it always going to be 16 or will it be dynamic?

[Anonymous]

What is the rational for wanting to show 16 ?

As in how would you want to calculate it ?

[#7]

logic is sum(F2)-8

[#8]

sum(F2)-8

[sunny_talwar · Accepted solution]

Try this expression:

If(Dimensionality() = 0, Sum(F2) - 8, Sum(F2))

[#10]

Thanks a lot.

how to add Total  in start instead of at end?