Pivot table issue

[#1]

Dear All,

Greetings.

There is a year and month wise data

Year	Month	Material	qty
2013	jan	`A	1
2013	feb	B	7
2013	mar	B	8
2013	jan	A	9
2013	feb	A	10
2013	mar	A	11
2014	jan	B	12
2014	feb	B	13
2014	mar	A	18
2014	jan	B	21
2014	feb	A	22
2014	mar	A	23

The user wants it in following format:

	Year	2013			2014			Avg Qty
Material	Month	feb	jan	mar	feb	jan	mar
A		10	10	11	22	-	41	15.67
B		7	-	8	13	33	-	10.17

Is this extra column of 'Avg Qty' can be added without any year and month segregation? If yes, then how?

Pls Suggest.

Attaching herewith qvw for your reference.

[ecolomer]

This is not you need bud ...

[#3]

Thanks Enrique Colomer for your reply.

But the requirement is to add three more columns like 'Avg Qty', 'Stock in Hand', 'Avg Consumption' which shall show their total value regardless of Year And Month.

	Year	2013			2014			Avg Qty	Stock in Hand	Avg Consumption
Material	Month	jan	feb	mar	jan	feb	mar	value	value	value
A		10	10	11	-	22	41	value	value	value
B		-	7	8	33	13	-	value	value	value

[PrashantSangle]

Hi,

There is some limitation of Qlikview.

One of that is you can not add Expression after Dimension.

So If possible Find Some alternative Solution.

Regards

[Anonymous · Accepted solution]

take a look at this

[preminqlik]

hi

find attachment , hope this helps you

[#7]

Hope this will help you