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

Need to show percentage of two totals

Started by rteruyas, 17 Jan 2017 01:44:28 PM

Previous topic - Next topic

rteruyas

Good day guys, I've been around this issue for the last couple of days and I'm out of ideas. Maybe someone here has faced a similar situation or as a different approach to go.

I have a list of suppliers with QtyExpected and QtyDelivered as measures.  I'm using active reports, and I have controls to select week and supplier
I've been asked to show a quota% (Total(QtyDelivered)/Total(QtyExpected))

Is there any way to represent only the calculation of % based on the selected controls? The method I've tried so far didnt work for me:
- Gauge visualization doesnt allow more than 1 measure
- I tried using a list to show totals only but I don't know how to display only subtotals (for the enterprise) and only the calculation

Any other ideas would be much appreciated
Thank you very much


I'd like to be able to show QtyExpected/QtyDelivered
Happy Reporting!
[Ray]