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.
is there a way to import data with months in columns (usual excel table view)? I have to transform the data so there are rows to cover each period in the upload data form, but I am wondering if there is a better way to just import the data as is with the months in the columns. please let me know what you think. thank you,
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…
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.…
