Volume Entry Worksheet - Training issue

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

Volume_81173.png

Accepted answers

All comments

Akhtar.shahbaz

Hi @CommunityMember128166

It looks like you filter line item summary is "None", Go to the blueprint of the filter module & can you try to change your filter line item summary to "Any"?

Thanks

Akhtar

Volume_81180.png

CommunityMember128166

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.

Volume_81180.png

CommunityMember128166

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.

Thanks,

Paul Thella

Volume_81180.png

CommunityMember128166

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.

Volume_81180.png

RemRemRem

Thanks - I came here to dig up this very problem, having come to the same conclusion (that the training-requested filter is what causes the summary by year to disappear). I hope the training team can correct the image in section 13.9.6 Activity: Confirm Layout of Volume Entry Page to remove the annual totals.

-Rachel

Volume_81180.png

Zees

Hey Guys,

I ran into the same issue, and after discussion with another internal community group, I found that I missed including the summary of Actual/ forecast line items in Sys00. Once you make the summary for Actual and Forcast to Any, and the total for FY20, FY19 should be populated in the REV02 forecast module view and on the worksheet page.

Volume_81180.png

Quick Links

Can you help?

Unanswered questions

Where can I find export file after running export process using machine task in a workflow?
I am testing export actions using workflow but its not generating any file when I am running the workflow, but the same process is generating export file when ran from the Actions→Process section. Is their any issue with the workflow functionality? Also, If I want to generate a file after completion of workflow and pull…
Automating Flat File Uploads to Anaplan Data Orchestrator (ADO) – Best Practices and Methods
Hello Anaplan Community, I am seeking guidance on the most effective ways to automatically upload flat files to Anaplan Data Orchestrator (ADO). Currently, our process involves loading flat files to an Anaplan Datahub using Anaplan APIs and custom Python scripting. With Anaplan Data Orchestrator's capabilities for data…
How to Design Simulation Planning in Anaplan with Multi-Level User Input and Step-by-Step Logging?
Hi Anaplan Community, I'm working on a simulation planning model where users need the flexibility to input pricing adjustments at any level of the product hierarchy, and I’d love your guidance on best practices. 📌 Scenario Overview: We have a 4-level product hierarchy: Brand Category Sub Category SKU (lowest level) The…