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