Hi Team,
Hope everyone is doing good!
I have a requirement where i have a stacked bar chart with Month(on X-Axis) and Level as another dimension.
Data will be like below
Month Level Amount
Jan-2021 L1 1000
Jan-2021 L2 1100
Jan-2021 L3 1200
Feb-2021 L1 2000
Feb-2021 L2 2100
Feb-2021 L3 2200
I have to create two expressions, First is: Sum(Amount) as 'Bar' and another one is 'Text as Popup'
For the second expression I need to calculate amount based on Month(irrespective of level)
Ex: For Jan-2021 value is 3300,For Feb-2021 value is 6300
When i move cursor on bar i have to show amount values Sum(Amount) based on Month,Level and Month wise sum(Amount)(irrespective of Level).
I tried with Aggr function it didn't work.
Can you guys please help me to achieve this requirement.
Regards,
QV11 User
