Hi, I can create a filter here in terms of months but I am not getting data for the line chart, where am I going wrong? Please help me on this.
@AyushT22 Hey, As per your screenshot, change the page selector from ALL products to a child item and it'll visible.
Hi @jagadishdash I did try with that but then also I am not able to get any data
Make summary as sum . u will get data
@AyushT22 - Make sure to keep the summary as sum to see the data at the Top/Parent level.
@AyushT22 In blueprint view, toggle the summary from None to SUM.
@AyushT22 The formula is at week level,
And you are using Months. Can you take a look at that and if not working share the Blueprint view. Thanks.
Thank you everyone for your suggestions it worked.
I thought a formula would be necessary to display this data properly.
Hi,
Anyone can assist me on how to Add a filter to this module to display Months only?
Thanks in advance
Create a system module with month dimension.
Create a Boolean line item with a formula TRUE.
Turn off summaries.
Use this line item as a filter for your module. I hope this helps.
Seyma 🌷🙂
@seymatas1 Thank you for inputs, however, I'm not able to proceed to display Months only.
Any ide what will be the selection to display months only? Weeks are still display in my modules.
I'm looking at below output in a per month.
2. Create a system module with month dimension.
3. Apply the filter to the time dimension of your weekly module:
4. Filter is working.
You can also consider creating a monthly module instead of applying a filter. A new module will increase your cell count but a filter will affect performance. There is a tradeoff and I usually prefer to increase size instead of affecting performance.
Thanks @seymatas1
I tried to filter the data using the Planning Period Filter Weeks Only line item in the SYS01 Time Settings by Week module. However, I'm not able to Filter it. Please see below screenshot.
Please assist.
Thank you.
Hello folks, Does anyone know how to work around the Polaris limitation of using the Formula or Ratio summary method alongside the Closing Balance within the same line item? I have a Business Unit list where the total (All BUs) must display the Corporate (1 of 20 leaf items under All BUs total) number of Unique Customers.…
Has anyone found success using Anaplan XL with Polaris models in a shared drive with or without concurrent users? My team has experienced a variety of errors, login failures, etc. sometimes it works, sometimes it doesn't. We've been recommended to save and edit files locally, which helps but certainly with its limitations…
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.…
