Problem with creating a pivot table

[#1]

I am fairly new to qlikview and I am trying to create a pivot table that will look something like this:

                         Quarter 1 2014                                   Quarter 4 2013

                    Domestic| International | Total        Domestic|International | Total

Division

ABC

DEF

The records that I have coming in

Year,

period (this would be the month of the sale),

Area (this would be 'DOM' for Domestic or 'INT' for International),

Division

Amount

I think my problem is splitting out the Domestic & International; not sure how to get it to split out like this.

Any help is appreciated.

[#2]

Can you post your qvw or datasource file?

[#3]

For your dimensions use Year, Period, Area, Division

For your expressions use Amount

[lironbaram · Accepted solution]

have a look at the attach example

[#5]

This is what my data would look like from the load

Fyear	Fperiod	Area	Item_Group	REV_Total
2014	1	DOM	C11910	10.25
2014	1	DOM	C19906	10.25
2014	1	DOM	C11910	90.28
2014	2	INT	C11910	13.59
2014	1	INT	C19906	11.09
2013	12	DOM	C11910	15.25
2013	12	DOM	C19906	11.75
2013	12	INT	C11910	21.25
2013	12	INT	C19906	15.25
DIVISION	ITEM_GROUP
ABC	C11910
DEF	C19906

[#6]

Perfect!!! Exactly what I was looking for!!!!

Thank you!!!!

[#7]

How did you get the columns to line up that way????

I am trying to drag & drop but it doesn't seem to work.

Also I would like to add at the bottom the following:

Int'l % of Total

[lironbaram]

hi you need to select the 3 dimension you want

and then to pivot the dimension you want to display horizontal

just drag the dimension label upward

i am attaching example with your data