Forum Discussion
Frozen Columns in a Matrix?
Thanks Ross73312.
I've followed all those steps and I get something that looks like this, even after turning off 'Stepped Layout'.
Column A Column B Column C Column D Column E Column F
SKU Name UPC CY Units CY Revenue PY Units PY Revenue
Kraft Smooth Peanut Butter 1KG Total 50 $250 40 $200
68100084245 50 $250 40 $200
If I proceed to turn off 'Row subtotals' within the Subtotals, I get something like this, more of what I'm looking for.
Column A Column B Column C Column D Column E Column F
SKU Name UPC CY Units CY Revenue PY Units PY Revenue
Kraft Smooth Peanut Butter 1KG 68100084245 50 $250 40 $200
Is there a way to turn on subtotals only for specific Rows and want it to apply to the first Nut Butter row?
For example, my rows in my Matrix are : Nut Butters, SKU Name, UPC
Not for specific rows, no.