In-Column subtotals and totals using multiple Date types

[#1]

Hi all,

I'm new to Qlikview and am completely stymied on how to achieve the following:

1) I have no idea if I should start with a pivot table base, or a straight table, or something else.

2) I have no idea how to put QTD and YTD rows interspersed with Months

3) Etc

Thanks!

[#2]

Unfortunately, it's the same file. It looks ok on my Qliview Desktop.

Please whatch this video around minute 6. It will show you how to drag the fields in the pivot table.

QlikView | Pivot Tables - YouTube

[qlikviewwizard]

Hi WonderBoy

Can you attach the sample data? It will help the folks to give quick and better solution. Thank You.

[#4]

Nuno,

You're a genius! Thanks so much!

Cheers,

Sam