I have to create a report like below :
All aggregate fields available in datasource but for the Rate it should be a calculation where Rate -> Failed - > Volume = Aggregate ->(Failed Volume / Total Settled Failed Volume)
and Rate Failed Value = Aggregate -- > (Failed Value / Total settled Failed value).
Not sure how I can create a report in this format using the calculation .
Please any help would be much appreciated .
Can you provide some sample data & workbook please ?
I don't think you will do it in a worksheet, but you might in a dashboard.