Get the sum by month in columns

[Ludovicooo]

Hello,

Hello everybody,

I try to obtain with a formula the grand total for each month in my shops regarding the global. I try to have in a column the sum of visits for july for example (10 000 visits + 30 000 visits + 60 000) in total visits column linked to the month and not the global.

Example :

Shop A > 10 000 Visits > Visit rate : 10% > July  > Total visits 100 000

Shop B > 30 000 visits > Visit rate : 30% > July  > Total visits 100 000

Shop C > 60 000 visits > Visit rate : 60% > July  > Total visits 100 000

Grand total >>>>>>>>  300K€

I've tried this formula but it gives only the sum of visits for all the months and not the global visits by month : 

test = SUMX(ALL('Couts Piano 2'),'Couts Piano 2'[Total Server call])

Any idea how can I have total visits in colum by month ?

Thanks a lot

[Anonymous]

Try using this.

Total Visit = calculate (sum('Couts Piano 2'),ALL([Total Server call])

Best Regards,
Shreya

Appreciate with a Kudos!! (Click the Thumbs Up Button)
Did I answer your question? Mark my post as a solution!

[Ludovicooo]

Hello shreyamukkawar

PREVIEW

Thank you for your answer

Unfortunately not work. "

The SUM function only accepts a column reference as an argument.