How to get Stacked Barchart with individual percentages and one final absolute value.

[#1]

Hello All,

I've one sample barchart to explain the problem scenario

From the above barchart:

* I've Dimensions: Type,New_Campaign_Name

         Measure=Total

                         fx=sum(Sum)

* I'm getting Absolute values in front of each bars like 2071,1995 etc.

* Adding to these values i should get individual percentages for each each campaigns in each bars(I mean to say three seperate percentage in first bar)

Changes in expressions Recommented

Thanks

[#2]

Below is my Bar Chart(if i made it grouped)

[kkkumar82]

Hi Gotham,

I think for now the current version doesn't have this feature

[#4]

Can we do it by applying formula in the expression,,,

For eg:sum(Sum) we are getting 879,909,283 for the first bar, can we convert into percentage

[kkkumar82]

Write the formula like

Sum(Sales)/Sum(Total Sales) and follow the below pic

[#6]

Yea i'm getting percentages for individual, but can i get total absolute value at the end like

[kkkumar82]

Based on your pic if for march , if you don't have the second dimension values then there is a chance of getting like that

but in a stacked bar when you have two dimensions then there is no change of getting stacked bar for some bars and for the last bar absolute value.

[kkkumar82]

R u getting the percentages in sense like what you share? if so what have done for that?

[#9]

No the above pic is just a sample to get the things done.

But the problem here is in stacked we are getting sum-up percentage, can't we get divided percentage for all the campaigns over there

[kkkumar82]

for now no in Sense, but if you have observed if you hover your mouse on the sub parts of bar , you will get the pop up

showing the percentage value