How to show the Total and sub total in one Table in qlikview

[Karim_Khan]

Hi Team,

  I wanted to show the  Total of the current [Sales Level 1 ] and at the end it should show the sum of All [Sales Level 1].

I will pass the selection on [Sales Level 2].Am able to calculate the first two field.But I am unable to get the %.

	Sales Level 2 Customer Count Bookings % Bookings Avg Deal Size Total 7424 222457000.8 9.41% 33225.42844 CANADA 631 20932019.92 9.41% 33225.42844 LATIN AMERICA 741 29788670.25 9.41% 33225.42844 US COMMERCIAL 4098 58816212.46 9.41% 33225.42844 US ENTERPRISE 549 51737137 9.41% 33225.42844 US OTHER 3 5475872.92 9.41% 33225.42844 US PS MARKET SEGMENT 1402 55707088.24 9.41% 33225.42844

As per above Table am able to calculate Customer Count and Bookings.Now I want % Bookings which should show correctly as per

Calculation.

Bookings=Total/Sales Level 2

But its capturing only CANADA value in all Field which is wrong.I want the correct % Bookings value for remaining sales Level 2 also.

E.g :

If I select [Sales Level 1 ]  AMERICAS.Then it should show the calculated % bookings value for [Sales Level 2 ]  in the above table.

Expression for % Bookings as follow

=sum({$<[Fiscal Year] = {$(=only([Fiscal Year]))},[Month in Fiscal Year] = {'<=$(=only([Month in Fiscal Year]))'},CATEGORY={'IOT'},[Sales Level 1]=, [Sales Level 2]={$(vSel2)}>} [Net Bookings])/sum({$<[Fiscal Year] = {$(=only([Fiscal Year]))},[Month in Fiscal Year] = {'<=$(=only([Month in Fiscal Year]))'},CATEGORY={'IOT'},[Sales Level 2]=, [Sales Level 1]={$(vSel1)}>} [Net Bookings])

Regards,

KK

[kaushiknsolanki]

Hi,

It is difficult to understand your issue without the data.

If possible kindly upload some sample data and try to explain your problem.

Regards,

Kaushik Solanki