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 everyone, I hope you're doing well. I'm posting because two of my coworkers are trying to use the Anaplan Excel Add-In Series 4, but they're running into an issue during the connection setup process. When they go to New → New Read-Only Connection (or New Connection) and reach the "Select a Customer" step, no…
Why in my model output is blank, after send explainability data.
I am working on a use case where I need to display the top 5 lines of a module as individual lines, while grouping all remaining lines under an "Others" category. The module is dimensioned by multiple composite hierarchy lists, along with Time and Version. To achieve this, I need to use the RANK function with the Ranking…
