How to have the correct Percentage(%) through Pivot view

Question & Answer
,
1

Need to have the correct percentage in pivot view & also in the total section.

image

I used Δ % = (ACT / BDG) * 100 which is not coming correct

Note:
Both fields are aggregated.

2

Hello @NirmalSingh !

That is interesting, could you share how you are aggregating ACT and BDG? Can I assume that the each of the pivot rows have a few underlying attributes to get those values i.e. region, product, date, etc…?

3

Hi @duncan Thank you for the response.

We have Area, Country , Customer in the Column & Brand in the Rows.

ACT is the Order Total Amount

sum(order_total)

BDG is the amount which I am getting from Excel Sheet which I am uploading in the dataset based on Area, Country , Customer & Brand.

Let me know if you still need anything more.

Thank you in Advance.

4

Hi @NirmalSingh, please can you create a sample dashboard with sample dataset showing your problem state using Arena and post it here. (Details on using Arena can be found here - QuickSight Arena).

5

Hi @NirmalSingh. Checking in. We have not heard back from you regarding your question. We’d still like to help. If we do not hear back in the next 3 days, we will archive the question.