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