Hi,
I'm trying to create a time filter that will only ever return current month and December 2020. I've managed to create a filter for both using separate line items, struggling to combine and allow users to view.
Any suggestions?
Thanks.
Hi @hinamahmood1994
You can try this:
1. Add one line item to combine the both condition current period & december 2020 filter
2. In your target module use this as a filter
Hope this helps!
Thanks
Akhtar
You could do this by creating 3 line items
A. One which contains the logic for Current Month boolean format & time dimensioned - ITEM(TIME) = Current Month
B. One which contains the logic for December 2020 boolean format & time dimensioned - I wouldn't recommend hardcoding so maybe a line item where you choose the month by boolean (so this is really a setting)
C. One which combines the logic boolean format & time dimensioned = A OR B
I hope this helps!
Usman
Thank You! I was using And to combine my two line items instead of OR.
Hina 🙂
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.…