Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 %.
|
---|
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
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