Pivot Table Format- Add Manual rows

[#1]

Hi,

I have finance report i want to create manual row in the same reports example:

i have

Sales

Cost of sales

Gross Profit = Total , all these data from data source just i need to add one more row for

Gross Profit % Sales -

Group	Value	Group % Sales
Sales	100	100 %100
Cost Of Sales	50	50 %100
Gross Profit(Sales+ CoS	150	150 % 100
Gross Profit % Sales	150/100	(150/100) % 100

Please help me to create this format.

[Colin-Albert]

The best way to do this for financial reports is to use a straight table not a pivot table.

Have a look at this thread for more details. http://community.qlik.com/docs/DOC-3324