Table structure with total of selected fields

[Narz]

Hi all,

I have the Source as cross table. I am trying to display the straight table similar to Pivot table. I don't want to display as sub fields. A, B, C, D.. are the field names which I have to group and make total. Please help me to achieve this.

ColumnName	Division 1	Division 2	Division 3	Division 4	Division 5	Total
A	5	12	13	20	0	50
B	6
(A+B)	11
C	2
D	-5
E	1
(C+D+E)	-2
F	8
G	2
F+G	10
Total	19

Thanks,

Natheera

[PrashantSangle]

Yes it is possible. but for that you must have the logic for grouping fields. if you have that then you can achieve it in script as well as front end expression.

Regards,

Prashant Sangle

[Narz]

Hi @PrashantSangle  Thanks for the reply. I am trying to achieve this. If any sample script available kindly share.

[Aasir]

Load your Data to in and use below

ResultTable:
PivotTable
LOAD
Group,
[Division 1] as A,
[Division 2] as B,
[Division 3] as C,
[Division 4] as D,
[Division 5] as E
RESIDENT YourSourceTable;
 

Hope this help 

[Narz · Accepted solution]

Able to achieve the above using Valuelist - 

https://community.qlik.com/t5/Design/ValueList-For-those-tricky-situations/ba-p/1476275.

Dimension: ValueList('A', 'B','Total ')
Measure Expression: Pick(Match(ValueList('A', 'B','Total '),Sum({<F1={'A'}>}Values), Sum({<F1={'B'}>}Values), 

Sum({<F1={'A','B'}>}Values)