Hi all,
Does anyone know which approach is better to add the "Trading Margin %", "Gross Profit %" at row level as highlighted yellow below, which is dynamic and change based on the filtering we made in dashboard? Any suggestions are welcome. Thanks.
You could do this in Designer
Hi Cindy,
Good Day ! I see, but do you mean by apply pivot in designer to achieve this?
Thanks.
No, I meant that in Designer you can, essentially, put the fields anywhere you want. There are label boxes and data boxes. Meaning, if you add an expression to a report, there will be a label box and the expression box, which you can move around into any position. If you increase the size of the detail band, you could put the labels and data boxes vertically like this instead of horizontally.