Hi All,
Bar chart has 2 dimensions and the below options in Presentation tab is selected.
The format is passed to the expression through a variable using 'Num( expression,vformat)'
where vformat = Pick(Match(Order,1,2,3,4),'#,###','#,###','###0.00','###0.00')
When passing the format directly in the expression (i.e Num( expression,'###0.00')), the total shown on the bar chart is also formatted as expected.
But when passing format through variable, the values populated on bar are in the expected format but Total doesn't.
Request your inputs on this as i need to pass the format dynamically.
@jagan @sunny_talwar Please help
