Hi! I would like to use a mulitvalue parameter to allow the dashboard user to select multiple months at a time and see the total sales. The calculation below works well when one or more months are selected in the parameterized control filter, but if I want to see the total sales for all months the calculation returns no value.
sumIf({sales}, in({Month}, ${Month}))
The Month parameter and the Month field are both integers.
Thanks in advance!
Hello @ryann.schuessler,
Do you mean that when the user selects “Select All” or selects all the months then you see no values? If this is the case, it is possible that it is because the query against the datasource might be formed in a different way, not using the list of all Months, but a * or something special.
Maybe you can try adding an ifelse in case the sumif = 0 and do a regular sum?
Hope this helps!
Hi @ryann.schuessler,
It’s been awhile since we last heard from you; did you have any additional questions regarding your initial topic or were you able to find a work around?
If we do not hear back within the next 3 business days, I’ll go ahead and close out this topic.
Thank you!
Hi @ryann.schuessler,
Since we haven’t heard back, I’ll go ahead and close out this topic. However, if you have any additional questions, feel free to create a new post in the community and link this discussion for relevant information if needed.
Thank you!