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...
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.