Dual function in expression

[#1]

Hi All,

I have a weird problem with my stack chart. I used dual to get both Percentage and Value in the chart. However, only few of the percentage is  populated  and some  are not populated. The Percentage values of those shown in the chart are fine but the rest why are they invisible ..not sure why? Could anybody help me in this regards?

The stacked bar chart has 2 dimension and 1 expression.

Formula used:

=dual( num(Aggr(sum([Total Count]),Source,Year)/Aggr(sum([Total Count]),Year),'0.00%') & Chr(10)& num(sum([Total Count]),'#,##0'),num(sum([Total Count]),'#,##0'))

Thanks and regards,

Vj

[#2 · Accepted solution]

After struggling for more than a day, found the simple solution for populating the percentages...

dual(num(sum([Total Count])/sum(Total<Year> [Total Count]),'0.00%')& Chr(10)& num(sum([Total Count]),'#,##0'),num(sum([Total Count]),'#,##0'))