Moving Value Columns on a Pivot Table

Question & Answer
, ,
1

Hi all, I currently have a table just like Table 1 on QS. However, I want to make it look like Table 2.
Is this doable? I am not able to move the contract amount column to the left.

(Both contract amount and invoice amount are level-aware calculations at different levels)

image
image1640×822 52.4 KB

Thanks!

2

Hi @mateoleon210,

If you want to move Contract Amount to “Rows” field well of your pivot table, you have to use LAC-W instead of LAC-A to calculate it. If you share your current calculated field for Contract Amount, I can be more specific.

3

Hi David, my calculated fields are the following:

min(contract_amount,[contract_id])
min(invoice_amount,[invoice_id])

Thanks!

4

If you use minOver(contract_amount, [contract_id], PRE_AGG) for your calculated field, you should be able to move it to the Rows field well, to the left of Invoice Number.

5

Thank you! This is perfect