That's easy, I know how to do that, but the thing is that I want another Straight table with the following values
Company Price Qty
Head & Shoulders $35.00 13
Total $35.00 13
This is a simple example, with the example that I have, I can't just calculate it again, because of some conditions that one of the table has, so what I did was CLONE THE STRAIGHT TABLE THEN SET THE "SHOW ROWS" TO 0, however the problem is that I don't know how to add the "Head & Shoulder" row.
I repeat, I can't do the same exact calculation Meaning I can't do a Sum(price) and sum(quantity), because this works in my example, but not with what I'm doing.
1 - Is there a way that I can call the same total value that I have in the other Straight table?
2- Is there a way that I can copy the total row, and then add a custome column to it?
Re: How to add a custom total row in a straight table?
1. No, you cannot reference cell values in other objects. Only an expression can calculate that value. So you need to reuse the same expression.
2. No, a total row (or any row) cannot be copied. QV is not a spreadsheet. You can change the label of the total. You can also create a calculated dimension to show any values you want with the valuelist function. For example =valuelist('Head & Shoulder'). Your expression would then be something like =if(valuelist('Head & Shoulder')='Head & Shoulder', sum(price)). Replace sum(price) with whatever expression that calculates the value you want.