Hi,
How to hide the sync time period that are blank in my Management reporting ?
Thanks in advance for helping.
Tom
Hello,
You can use a filter to hide blank values.
Starting Situation:
Step 1: Add a filter to columns to hide 0 values
End Situation:
In case you have multiple line items you can create a support line item called "filter amount", which is the sum of all absolute values.
For example "Filter Item = ABS(Item1) + ABS(Item2) + ABS(Item3)" and then use that for filtering. Now months where only one line item would not equal 0 would still be visible.
Thanks @Lehtohen for commenting.
Applying filter would not work as there are data in my future quarter.
They are blank because i enables the Time Sync and Hierarchy filter.
We've been building a tool called aplan4sheets and we'd genuinely like input from this community — both on what we've built so far and on what we should prioritize next. The problem we set out to solve: Anaplan's Excel add-in is Windows-centric, and there's no real native way to pivot Anaplan data in Google Sheets. We…
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…
Estimated Level of Effort:4-8 Hours of Model Building Level of Difficulty: Beginner Recommended Training: L2 Model Builder Training Persona: Casual Model Builder Potential ROI: Decreased planning time Increased accuracy of targets/spreads You Might Also Like: * Historical Snapshotting Top-Down Allocations Whether it's…
