Hi Experts, I am building the worksheet and in the output worksheet, I am missing the Year Total for some reason.
I went back and looked at the 'REV02 Volume Inputs' and its looks good. Even when I added this grid to this worksheet, I am getting the summary of the months as FY20, FY21, but when I apply the filter as per the training notes, I am missing this sum column of all months.
Click Configure grid:
- Data Source: Custom views > REV02 Volume Inputs module
- Pivot:
- Pages: G3 Location list, Line Items
- Columns: Time
- Rows: P2 Products list
- Add filter to show only Forecast Periods (filter on Time dimension)
- Other Options:
- Allow editing: ON
- Allow pivot: ON
- P2 Products Hierarchy filter: OFF
- Time Hierarchy filter: OFF
Adjust context selector options for the page:
- G3 Locations context selectors: retain default settings
- Select Label for Line Items context selector settings (Click gear icon next to Volumes to change settings)
For filter, I am selecting Columns > SYS00 Time settings and selecting the Future months
Can you someone guide me why I am not able to match with the expected output. The only part I am missing is the year column (FY20, FY21).