We just upgraded our server and happy to learn the new feature of mini chart in straight table.
I am Ok to use the sparkline and bar chart. However, I can't work out a correct positive/negative mini chart.
What I want to do is showing a positive / negative indicators for improved market share in quarter (compared to the previous one)
Expression for Market share are sth like:
=
Sum({$<PERSPECTIVE={"$(=vPerspective)"} >} [#CQ_SALES])
/
Sum({$<PERSPECTIVE={"$(=vPerspective)"} >} TOTAL [#CQ_SALES])
How can I make positive growth (market share) as 1 and negative growth as -1 and show it correctly in the mini-chart?
