Help

[panipat1990]

Dear Team,

i stuck a requirement.For this i am sharing Excel.requirement is I want to make a pivot table.

where dimension is article_code And Fiscal Month.

But Expression be set on monthend. Suppose in Sep Month we Have 10 to 20 Dates..But i want t show only Monthend Date Regading Amount on Below Column Sep Month..Same As  next month.i want to show amount each month below only monthend value

Header 1	Header 2	Header 3	Header 4	Header 5	Header 6
Article_Code	Fiscal Month	Aug	Sep	Oct	Nov
10001		100	-	-
10002		-	200	-
10003		-	-	300