Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a problem in bar chart while i was trying to write rangesum() function.
There are screenshots of table and bar chart.
In table, formula is: "küm.ciro"/"küm.ton"
küm.ciro --> rangesum( before( sum([$(vCurrency) Satış]),0,NoOfColumns(TOTAL) ) )
küm.ton ---> rangesum( before( sum([KG Satış]),0,NoOfColumns(TOTAL) ) )/1000
In bar chart, formula is: (sum([$(vCurrency) Satış]) / sum([KG Satış]))*1000
This means that -for example in second column.-
table chart shows us (FirstValue + SecondValue) / 2 = (1.877,xx + 1.904,xx) / 2 = 1.891,xx
bar chart shows us only SecondValue = 1.904
I have to do this in bar chart but dont know how to do.
Thank you for your help.
I used RangeAvg and Above but bar chart and pivot table doesnt match.