This content has been marked as final.
Show 6 replies
-
Re: total value
youssef belloum Mar 7, 2018 8:34 AM (in response to onur yilmaz)Hi,
take a look at this, you have multiple solution
-
Re: total value
Jahanzeb Hashmi Mar 7, 2018 8:51 AM (in response to onur yilmaz)try this
Dim
=ValueList('Total')
Measure
if(Valuelist('Total') = 'Total',Sum(G)+Sum(NG))
-
Re: total value
onur yilmaz Mar 7, 2018 9:19 AM (in response to Jahanzeb Hashmi)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.
-
Re: total value
Jahanzeb Hashmi Mar 7, 2018 9:37 AM (in response to onur yilmaz)I think you can show all three have you given a try?
-
Re: total value
Jahanzeb Hashmi Mar 7, 2018 9:39 AM (in response to Jahanzeb Hashmi)=ValueList('Total','G','NG')
if(Valuelist('Total','G','NG') = 'Total',Sum(G)+Sum(NG),if(Valuelist('Total','G','NG') = 'G',Sum(G),Sum(NG))
-
Re: total value
onur yilmaz Mar 7, 2018 9:55 AM (in response to Jahanzeb Hashmi)Many thanks for the prompt reply, this worked perferctly for me.
-
-
-
-