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...
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.
If I use TOTAL, the result is the sum of all my selection... not just the column.
Here my QVW....
Retrieving data ...