1. I need to create customized subtotals as shown in the sample output.xls file. Is this possible in Qlikview? I also want to use the input box to alternate between showing and not showing the customized subtotals (refer to sample). I am currently showing subtotals via the Presentation tab, but this does not give me the look or grouping that I want.
2. I need to be able to show/hide columns that reference subtotals. I will show/hide columns using a list box. I already know how to show/hide columns, but I want to be able to show/hide columns effectively when showing subtotals.