Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everyone,
I have a bar chart with the dimension of 'TO_GROUP_OF_THIRD_PARTY' which has two values;
G for Group companies
NG for Non-Group companies.
Requirement is they also want to see the total values of G + NG values in bar chart with G and NG values. How can I get a bar chart with dimension of 'TO_GROUP_OF_THIRD_PARTY' and with values 'G','NG','Total'
they want to see the below charts in single bar chart with the dimension of TO_GROUP_OF_THIRD_PARTY.
meausure is sum of quantity.
Please suggest me any solution if anyone of you gone through the same problem.
Please suggest any appropriate solution...
Thanks.
OY
Hi,
take a look at this, you have multiple solution
try this
Dim
=ValueList('Total')
Measure
if(Valuelist('Total') = 'Total',Sum(G)+Sum(NG))
Hi Jahanzeb, thank you for your kind help.
As far as I understand, suggested code only shows the Total values, but I need all the values(G, NG, Total) in single bar chart.
I think you can show all three have you given a try?
=ValueList('Total','G','NG')
if(Valuelist('Total','G','NG') = 'Total',Sum(G)+Sum(NG),if(Valuelist('Total','G','NG') = 'G',Sum(G),Sum(NG))
Many thanks for the prompt reply, this worked perferctly for me.