Qlik View - Formating Partial Sums in Pivot Table

[Jthurston]

Hi All,

I am trying to format the following pivot table, the column Metric2 has 3 values, Income, Balances and Margin. I want to be able to format such that it is easy to distinguish between the three of them.

Is there anyway I can add a horizontal black line that would go all the way across my pivot table to make it easier to distinguish between Income, Balance and Margin?

Thanks!

[Brett_Bleess]

Probably the best idea would be to use the background colors potentially, see the Help:

http://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/Pivot_Table.htm

I think you want to do the Dimension background in this case, the help will guide you on what you need to do, hopefully that may do the trick.

Regards,
Brett