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 | |
| | | | | |