Sales by Product and Contract

[Anonymous]

Hello,

I would like to make the following calculation:

the sum of sales/ sum of sales by contract and calculate it monthly.

thank you

[neha_shirsath]

Hi Pablo,

I'm not getting what calculation you want.

Sum of sales/ sum of sales means?

Thanks.

[jcampbell474]

Please let me know if the attached file meets your requirements.

(The 'Test' table)

[Anil_Babu_Samineni · Accepted solution]

May be this?

Sum(Sales) / Sum(TOTAL <Contract, Month> Sales)

[mangalsk]

Hello,

This will do:

sum(Sales)/sum(TOTAL <Contract>Sales)

[Anonymous]

thank you both of you!! it works with the two options.

[effinty2112]

Hi Pablo

Try:

Sum(Sales)/Sum(TOTAL <Date, Product> Sales)

	Date	201701		201702
Product	Contract	NO	Yes	NO	Yes
1		88%	12%	70%	30%
2		26%	74%	41%	59%

cheers

Andrew

[veerendrakatika]

please mark as current to close this thread.

[arvind_patil]

Hi Pablo,

I think right ans is:

Sum(Sales) / Sum(TOTAL <Contract> Sales)

Thanks,

Arvind Patil