Relative/Aggr Data in a Two Dimensions Bar Chart

[shayraber]

Hi all,

i want to create a bar chart with two dimensions as follows: a Year-Month and a Products Group.

(i know that Mekko Chart does the work BUT i need a Stacked Bar Chart...)

i want to present the sum of sales per Prod-Group and Year-Month

BUT

i need that data in percentage and not in absolute values AND i need each bar to represent a 100% of that month's sales.

assuming i have two groups and two periods.

period 1: 100 units of group A and 50 units of group B

period 2: 100 units of group A and 50 units of group B

i need to have two stacked bars. each one with 33% for group B and 67% for group A.

instead,

i get two bars. each one 16% for group B and 33% for group A

any help?

[IAMDV]

Hi,

Please post whatever you've done so far. It's easy to work with your example.

Cheers,

DV

www.QlikShare.com

[antoniotiman · Accepted solution]

Hi Shay,

see attachment.

Regards,

Antonio

[shayraber]

thanks!