If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

how to calculate % of Total prior to filter application

Started by robblob, 05 Feb 2018 10:39:44 AM

Previous topic - Next topic

robblob

I feel like I'm overlooking something that should be obvious, but I'm unable to calculate % of total for a column prior to my 'Rank <= 25' filter.  I only want to see top 25 of my rank column, but I want to see % of total for everything prior to filtering to the top 25.  I know I can create a separate query that rolls up to the highest level and join it in, but that seem unnecessary for what seems like it should be very simple.  The % of total column works perfect when I make the top 25 filter required or disabled, so I got that going for me at least.  Any suggestions on what I can do to make this work without creating another query?




robblob

I may have posted this question prematurely.  I appear to have arrived at the solution by changing the detail aggregation on my '% of total' column from 'Calculated' to 'Total'.