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