Put the formula representing your logic - so basically all AGGREGATE AT / SUM BY statement with division into a column formula and then create a performance tile.
If you go into your analysis and "Exclude" the first 3 fields (left clik on each field and select "Exclude this field"), you will only get the final total for the fourth field.
I think that should give you what you need.
Yes but why force the query to retrieve detail data when an aggregated version is sufficient?
Prodney / Admin123
1 person found this helpful
True, I figured out the same while trying different options in the report.Thanks for your reply.I have implemented this and it works fine. I am marking your answer.