How to achieve Amount and Count format Pattern on same chart
Hi,
I'm using an variable which as Count/Amount options, On click of count the data of the chart should be displayed in number format and on click of amount the data should be displayed in money format,based on number of digits the money format should change to cr(crore),l(lakh),..automatically , but the format pattern does not change accordingly.
Below is the expression used in the chart:
sum(if(vRF='C',RFCount,
if(vRF='A',RFValue)))
vRF is the variable name used for selection of amount or count option, C-Count and A-Amount.
