KPI Measure to show total

[Winstodge]

Hi

I have a table that I have with a sum total at the top, I am trying to create a KPI measure to show the Total. Below is in the table.

=Num(RECE_QTY,'#,##0')*SUM(NET_PRICE / PRICE_UNIT)

i have tried using the rangesum but get "0"

=rangesum(Num(RECE_QTY,'#,##0',NoOfRows(total)))*RangeSum(NET_PRICE / PRICE_UNIT, NoOfRows(total))

I have also tried 

=Rangesum(Above(Column(8), 1, NoOfRows(TOTAL)))+RangeSum(Below(Column(8), 0, NoOfRows(TOTAL)))

But I still get a "0"

Any suggestion's would be welcome

Thank you

Winnie

[abhijitnalekar]

Hi @Winstodge ,

Can you please share an image of your table structure.

The reason being asking this as in Qliksene table we can move total from top to bottom also.

[Winstodge]

Hi Abhijitnalekar

Please see below

[abhijitnalekar]

Hi @Winstodge ,

Go to the Appearance--> Styling 

and disable the below Auto button 

Once you disable the Auto you will get the options 

Hope this helps you.

[Winstodge]

Apologies for not marking this as closed

I sorted this by using

=sum(NET_PRICE / PRICE_UNIT*RECE_QTY)

Regards