Total and SubTotal calculation

[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

MRKachhiaIMP‌jagan‌Kush141087‌gwassenaar‌

[settu_periasamy]

Hi Karim,

Can you give the expected output for the above selection?

[Karim_Khan]

HI Settu,

  PFB

Sales Level 2	Customer Count	Bookings	% Bookings
	6958	222457000.8	100%
CANADA	631	20932019.92	9.41%
LATIN AMERICA	741	29788670.25	13.39%
US COMMERCIAL	4098	58816212.46	26.44%
US ENTERPRISE	549	51737137	23.26%
US OTHER	3	5475872.92	2.46%
US PS MARKET SEGMENT	1402	55707088.24	25.04%