Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
jduluc12
Creator
Creator

How to add fixed values in the total of pivot table

Hi

I want to add some fixed values to the total row of the pivot table.

the expression looks something like this

if(RowNo()<>0 and not IsNull(RowNo()), sum({<Type={'A'}>}Amount),  sum({<Type={'A'}>}Amount) + 300 )

This ends up bringing all dimensions even if their Type is not 'A' and shows 300 as the values in the column.

Is there any better way to achieve it?

Thanks

Jean

Labels (1)
0 Replies