Pivot table and Only function issue

[#1]

Hi Guys ,

here is what my report looks like...which is what i want except one issue

I am using "Invoice.CustomerFullName" and "Invoice.Txndate" as an expression so QV is applying only() implicitly.

Every Invoice.RefNumber is unique so I get each invoice listed on my report.

The only problem that i am facing is when the item has only one invoice. for instance...Door Frame...it has only one invoice so the Total for this item also shows TxnDate and the CustomerFullname like "Vasquez, Anabel". It is happening because when only() does not find two different values then it shows the unique value.

Is there any way to get rid of this Txndate and CustomerFullname on the "Total" line even if item has only one invoice.

[#2 · Accepted solution]

Hi

See attached file

Regards,

Alex

[#3]

Thanks Alex!

It works.

I took a clue from your solution and did something like this because dimensions might change

if(RowNo()<>0  and not IsNull(RowNo()),Invoice.TxnDate)

this works too and I am not tied with dimensionality.