Cross tab style view

[#1]

Hi

I am trying to replicate the table attached. I have business unit and year as dimensions . And sum of Sales as my expression. I believe you have to drag the year dimension above the expression to get the cross tab type of view but cant get it to work ?

Thanks in advance

[petter]

Can you post a copy of your QlikView Application? Did you use a Pivot Table and then dragged the Year dimension?

[awhitfield]

Hi Sid,

are you using a pivot table? See the attached

Andy

[#4]

Peter and Andrew

Yes I am using a pivot

[#5]

So I got into a cross tab form but how would it show the sub totals line by line as they are in the spreadsheet rather than just cumulative totals for 2014 and 2015 ?