Total Sum on each level in Pivot Table

[rohitians]

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	-

[Brett_Bleess]

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