Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi!
Does anybody knows how to repeat the valeu of the first row from the first column over all the rows in the second column like the image bellow?
I could only repeat the first line...
Expression:
if you have identifier for first row (e.g. rowno) you can try
if (rowno()=2, previous(yourfieldinfirstrow), elsefield) as columnfield
It can be done using a TOTAL qualifier, but since you don't need the final grand total, you would need to specify the field name you are totaling it on.
Sum(TOTAL <FieldName> Sales)
FieldName would be the same one as the field with Partial Sum
I hope this helps.
Best,
Sunny
Hi Sunny,
If I use TOTAL, the result is the sum of all my selection... not just the column.
image below...
Here my QVW....