Total Sum on each level in Pivot Table

rohitians — Fri, 13 Dec 2019 11:54:16 GMT

Hi Friends,

I have three levels

I want total of AVB bank to be whole total ...same way DR1 total for the whole of DR1 and Anil Singh total to be of only his..is this possible so that i can compare how much Anil SIngh is contributing to whole of DR1 and Avb bank.

Count(DISTINCT{<Channel={'Avb Bank'},Application_Contract={"=sum({<Channel={'Avb Bank'},TransFlag={1},Product_Code-={'$(vExcludeProductCodes)'},GL_Code={1},
FiscalMonth={$(=max({<TableFlag={1}>}FiscalMonth))},FiscalYear={$(=max({<TableFlag={1}>}FiscalYear))}>}LWM)>0"}
,FiscalMonth={"$(=max(FiscalMonth))"},FiscalYear={"$(=max(FiscalYear))"}>}Fsc_employee_id)

Thanks.

Channel	structure1	DR1	FSC Activation CM	FSC Activation PM	PMSD
AVB Bank	Totals	Totals	19723	17558	-
Growth Market NW	Totals	500	480	-
Anil Singh	100	80	-

Re: Total Sum on each level in Pivot Table

Brett_Bleess — Thu, 19 Dec 2019 20:24:41 GMT

This one is fairly complex, would think if you can attache sample QVW, that should help get some responses. The only thing I really have is Design Blog base URL, you can use that to search the posts there to see if you can find something that will help, not exactly which piece you may need here, so going to let you dig around yourself instead of me offering up something and being way off base.

https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog

This will also kick things back up in the list, so someone else may see it now and offer something more direct too.

Regards,
Brett

topic Total Sum on each level in Pivot Table in QlikView

Total Sum on each level in Pivot Table

Re: Total Sum on each level in Pivot Table