Blank Row

[upaliwije]

Hi Friends

I have in QV doc the following  Pivot Table

I want to insert a blank row in between PRD_CODE and report should look like below

Pls help me to this since what I tried did not work. I attach My QV Doc as well

[vinieme12]

I'm using Personal Edition so can't open your app. Check the attached sample

Just concatenated blank rows for Distinct Dimension values

In Script 

Concatenate(Transactions)

          LOAD Distinct Dim1,

              ' ' as Dim2                                          //Adding Blank dimension Rows

          Resident Transactions;

Chart Expression

if(sum(Expression1)=0,'',num(sum(Expression1),'$ ##,###'))

[upaliwije]

Thanks Vineeth,

It is bit difficult for me to apply your one to my Qv Doc