Repeat First Row

[#1]

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:

[Anonymous]

if you have identifier for first row (e.g. rowno) you can try

if (rowno()=2, previous(yourfieldinfirstrow), elsefield) as columnfield

[sunny_talwar]

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

[#4]

Hi Sunny,

If I use TOTAL, the result is the sum of all my selection... not just the column.

image below...

[#5]

Here my QVW....