I am attaching sample report here which i need to replicate in QlikView/Qlik Sense.
Note: Please make sure that formula at cell '14' in sample report.
In Qlik Tech We can do it
Dimension : DeptGroup
In Presentation select Dept Name And check Show Partial Sums and Subtotals at bottom
Hi Ritesh, Please go through the formula once in sample report. Its not just direct partial sums.
For instance: As per your snap shot total of depart c1 and c2 should be 245 not 90.