Two questions about the Totals

[#1]

Hello, need help again 😞

1) I have a straight table with three columns Cost, CurrentMarket, CurrentMarket/Cost*100

In total fields I have Sum(Cost), Sum(CurrentMarket), but I cant sum the (CurrentMarket/Cost*100) cause there is no sense. I want to have an expression in that total field like (Sum(CurrentMarket)/Sum(Cost)*100). Is it possible? Maybe in Pivot table?

2) If the answer on 1st question is yes here is the second question.

I want to have more than one row total 'cause I want to count the aggregation values under some field by different ways.

Is this possible?

Thank you so much.

[#2 · Accepted solution]

1) Yes, it's possible. You need use Sum(CurrentMarket)/Sum(Cost)*100 as expression. On 'Expressions' tab of a chart for the Expression in 'Total Mode' block you need select 'Expression Total'

2) can you show an example of the data/chart?

[#3]

1) Thank you that's really smart and it works.

2) You want chart in QV file? Or just a data?

Here is an example. Total in piastres counts as (Total in $ values)*Course

ProductName	Cost	CurrentMarket	%%
Gold	$10	$12	120%
Silver	$5	$5.5	110%
TOTAL in $	$15	$17.5	117%
TOTAL in piastres	250	292	117%

[#4]

2) Something like this.