Calculated Gross Margin Row

[#1]

Hi :

I am trying to create a report that will show the Gross Margin,

The Sales & COS Category are obtained from the source data with the help of SQL statement, but finding it difficult to insert a "Row" (not column) in the pivot table that will subtract the COS from Sales and show the Gross Margin by Month.

I tried creating an inline table, but the Gross Margin is pushed to the end and does not allocate by Month.

(Sample data in attached excel file)

Appreciate any help in solving this issue.

thanks

Kumar

Hi

Have added a new sheet with a sample source data

thanks

[Gysbert_Wassenaar]

Can you post an excel file with source data too?

[#3]

Hi

Have added a new sheet with a sample source data

[Gysbert_Wassenaar · Accepted solution]

See attached qvw for one solution.

[#5]

Thanks Gysbert, it worked appreciate the help