Need to be able to add a gross profit into a existing pivot table

Question & Answer
, ,
1

I have refences that seem to show being able to add a subtotal in the middle of pivot table without having to make a different table, Introducing advanced formatting options for pivot table totals and subtotals in Amazon QuickSight. However I am unable to find details on how to add a row.

image
image347×419 17.1 KB

1 Like
2

Hello @Sanders77 Welcome to community! Hope this message finds you well

If I understand what you mean, you need:
add two different rows on your pivot table and to make the subtotal appears, go to Format Visual>Pivot Options>Layout and them change Hierarchy for Tabular

Please, tell me if it’s work!! :smiley:

4

Thank you @lary_andr for the warm welcome. Afraid I did a poor job explaining what I am needing to do so this and Tabular didn’t appear to accomplish this change. I need to be able to do a sub total of total Revenues -Cost of Sales as GROSS PROFIT but not affect the existing totaling of NET PROFIT. I believe this would a standard need for income statements so I expect its just a lack of understanding on my side. The order is import and GROSS PROFIT must come after COST OF SALES but before EXPENSES.

5

Hi @Sanders77

See if this helps

6

Hi @Giridhar.Prabhu

I tried both these already and have adjusted my dataset to be able to create a subtotal for gross profit as desired. However that leads a separate issue of needing to be able to conditionally not display a second subtotal for expense. For an Income Statement need a way to to subtotal only for revenue and cost of sales as gross profit, then expense should not make/display subtotal any suggestion on conditional sub totals?

7

Hello @Sanders77 !

Are you still working on this issue or were you able to find a solution?

To clarify, it sounds like you want to have subtotal appear for some of your columns but not all in the subtotal row, and also be in a specific order. Is your gross profit field a pre-calculated field or are you expecting the pivot table to roll that total up for you?

8

Hi @duncan

I have been able to work around this by reworking accounting structure in dataset. Its not ideal and required quite a large data prep rework. Conditional subtotals in pivot tables might be something to consider as road map item to avoid so much data prep work.

Thanks
David

1 Like