Show Total in Module even after applying filters

Hi All,

In one of my moduel having a column "Rebate Payment Amount" which has values, and also we set the show TOTAL on Above for giving total aggregated values as single value, it works only if we didn't apply any filters on the remaining columns in the module.

How to show the 'Total' i.e. sum of all rows for the column in top in the module even after applying filters ?

Need help from you on this.

Thanks,

Satish.

Accepted answers

All comments

?.Szyma_ski

Hi Samarapalli,

I assume you are using boolean formatted line item to filter those columns. If so open Blueprint for module that has filter line item. Scroll right to get Summary column and change summary type from default None value to Any.

Hope it helps,

Regards Lukasz

samarapalli

Hi Szymanski, thanks for your response.

Filtered line item(i.e "Contract Group") is not the boolean type, its a "LIST" format. And also having an "Rebate Payment Amount" line item is "Number" format which i want to see always its "Total" value even if the filters applied to other columns or not.

Thanks,

Satish.

nathan_rudman

Hi samarapalli,

the format doesn't really matter: whatever it is, you need to check the "summary" setting of the line item you are filtering on.

For a list formatted one , if you filter is "is not blank" then you just have to select the summary type "last non blank"

mk111221

I am having the same issue. I am filtering on a Boolean but even after selecting any in the summary, the total is still not correct.

mk111221

Going along with this, if I want total orders and FILTER out an industry, such as Industry <> Retail, then my total orders should sum to everything EXCEPT retail and even though with the filter I don't see Retail the total still includes it. I have tried messing with the summation nothing works.

karl.mcphee

Hi there,

It's important to realise that when you apply a filter to a module it does not affect the actual calculation of a total. So for example, if your total level sums together all orders then it will still do that even if the filter is set to only display orders for a particular industry. Dynamic totalling depending on filters is not something that happens today (although agree would be very useful and definitely worth adding as an enhancement request).

A very simple way around this which I tend to use now is the quick sum bar. For example, you change your filter so that it does not show the total anymore (as this could be confusing) but then use the functionality where you can highlight a column and get a total in the quick sum bar at the bottom right of the screen. This should then enable your users to filter for a particular industry and then get the total of orders by highlighting the column and looking at the quick sum.

Hope this helps

mk111221

The issue with that is that they want to see the total in a dashboard. So in order to accomplish this, we have to create another line item for each measure that they want to see excluding out Retail. THis is a lot of overhead and it shouldn't be necessary. So you either end up with multiple modules doing the exact same thing just with different exclusions or multiple line items with the exclusions.

RyanD

@karl.mcphee
If you wanted the exact functionality of being able to see a roll-up sum for the selected list items you could use a list subset in lieu of a filter. A lot of limitations with this approach, and you would need to create a module for each subset view.

Quick Links

Can you help?

Unanswered questions

Create a Filter to show all the elements of that level based on selection in hierarchy
Hello Community members, Requirement Details: I have 5 levels of composite hierarchy list (A1, A2, A3, A4, A5). I have published a module in UX, Now the requirement is If user select a list member from A4 level in the context selector or Custom Filter I have to display all the list members under that A4 level. How can I…
import monthly data with months in columns
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,
Cloudworks Big Query Integration Fail
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…