Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
This question is Not Answered.(Mark as assumed answered)
Let's say I have the following table:
Product Price Qty
food $5.00 4
bed $10.00 6
bread $20.00 3
Total $35.00 13
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?
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.