Show Total in Module even after applying filters

Options
samarapalli
samarapalli Member, ALL USERS, Partner Posts: 5 Occasional Contributor
in Planning & Modeling

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.

Tagged:

Comments

  • Ł.Szymański
    Ł.Szymański Member Posts: 5 Contributor

    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
    samarapalli Member, ALL USERS, Partner Posts: 5 Occasional Contributor

    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.

  • mk111221
    mk111221 Member, ALL USERS Posts: 5 Occasional Contributor

    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
    mk111221 Member, ALL USERS Posts: 5 Occasional Contributor

    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.

  • mk111221
    mk111221 Member, ALL USERS Posts: 5 Occasional Contributor

    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.  

Categories