I need to create a report which can display tabular data and it's total for each dimension value. E.g. For each program I need to display project details and total.
The format of the report should look like this. Both Program and Project are dimensions and are linked properly to show the relationship in QlikView.
you can use Pivot Table Chart in order to display tabular datas, with Show Partial Sums option (Chart Properties > Presentation > Dimensions and Expressions).
Please take a look at the attachment. It seems near to your format.
Thanks Julien for your help. However the client needs the report in exact format which I mentioned. Also if I extend my requirement for each program I need to display one chart also below the tabular report.
