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
Pages: G3 Location list, Line Items
Rows: P2 Products list
Add filter to show only Forecast Periods (filter on Time dimension)
Thank you Akthar for the reply. I checked the module setting and its all good. Even when I configure this grid in the worksheet, I see the sub totals for each Year, but only when applying the filter its not showing up as per training. I changed to Any option and still don't see any change.
I checked all settings. Until I pull this grid card and pivot, everything looks good. Its changing only after I apply the filter option. Attached the screenshot before applying time filter to show the forecast periods.
Steps I am following:
1. Once grid is added to the worksheet, its shows up months and FY20 , FY21 at the end
2. Then I click on filter, Select columns
3. For time, show Items that match - ANY
4. Click on rule, Select the SYS00 TIME Settings
5. Select Line Item as 'Forecast Month only'
6. Filter Condition ' Is True'
7. Then Click apply and update
Then I will miss the year columns. Looks very small change, but unable to figure out.
Based on all the checks, it was found the filter by months is causing this issue. This has nothing to do with the data or modules. If we had a filter made by Year, then it will show up, but since we have used a filter by months, its not showing year. if we have to see we need to use the hide and show option. This issue has been resolved and purely caused due to training steps mismatch.