Sub-total as calculated field (?)

[#1]

Hi,

The following is an overview of what the client wants:

On the first column, the white cells represent dimmension (let's call him dim1) with values like 'Revenues from Services(temp worker), Employee expenses, IT Expenses'. Grey cells show subtotal (Total Revenues from services, Total Costs of services, Total operating expenses) but also calculated field like Gross Prodit ([Total Revenue from services] - [Total costs of services]).

To make things even more complicated, the second column ('Actual') needs to show value on the selected period, P-1 the previous period, ect...

Can this be done in Qlikview? without 1000 expressions...

Your help is much appericiated!

Dror

[#2 · Accepted solution]

This may be helpful:

http://community.qlik.com/docs/DOC-3324

[#3]

Nice approach!

There is however GP% which is calculated field and has a different format. Possible solution would be to add to extra fields to the report config. sheet (ExecProfitLoss):

1.  Expression - sum({<Dim1 = {'x'}>}amount) / sum({<Dim1 = {'y'}>}amount)

2.  Format - '%#0.0

'