Nested aggregation help required

Question & Answer
, , , , ,
1

In the following data set:
Case id Finance id Revenue Payment
1 BR_1 31249 12,893
1 BR_2 8439 3153
1 BR_2 8439 222
1 BR_1 31249 15625
1 BR_2 8439 3,942
1 BR_2 8439 278

I am trying to create a pivot which shows output as:
Case id Finance id Revenue/Finance id Cost/Finance id Revenue/Case id Cost/Case id
1 BR_1 31249 28518 39688 36113
BR_2 8439 7595 39688 36113

I have got Revenue/Finance id and Cos/Finance id as min(Revenue,[Finance id]) and min(Revenue,[Finance id])

But not able to get it for case id. Also, I want to keep Revenue/Case id and Cost/Case id fixed irrespective of the filters. Please help here.

1 Like
2

Hello @Atul, welcome to the QuickSight community!

In order for me to guide you towards a solution, it would be super helpful if you are able to create a demo version of this analysis in QuickSight Arena. This will allow me to visualize the calculated fields you are wanting to build and create a solution in a QuickSight environment.

I don’t entirely understand how your data is set up which makes trying to debug the issue you are running into a little difficult. With some more information, I can help guide you further!

3

Hello @Atul, since we have not heard back from you, I wanted to check in and see if you can provide more information about the problem you are facing. If you are able to create an analysis in QuickSight Arena or provide more detail about the issue, I can help guide you further.

If we do not hear back from you in 3 days, I will archive this topic. Thank you!

4

Hello @Atul, since we have not heard back from you with any follow-up information, I will close out this topic. If you still need assistance with this issue, please post a new question in the community and link to this topic to provide relevant information. That will ensure you are at the top of the priority list for a response from one of our QuickSight experts. Thank you!