Help with multiple conditional expression based on user selection

[#1]

I have the field "month", which has values 1-12. I have another field, "num_mondays", which looks at each month and has the proper number of Mondays (4 or 5).

I have simple expressions in a pivot chart where I need to divide them by the number of Mondays, depending on the month selection.

For example, one expression I have is called Uploads YTD, and it's simply: sum({$<CALENDAR_YEAR_A = {2017}>} ActualHits)

I don't know how to divide that by num_mondays, based on user selection of month in listbox.

[Anonymous]

why not sum({$<CALENDAR_YEAR_A = {2017}>} ActualHits) /num_mondays if you are using month as dimension??

[#3]

I'm not using month as a dimension, I'm using state as a dimension

[Anonymous]

Can you please share a sample if sum({$<CALENDAR_YEAR_A = {2017}>} ActualHits) /num_mondays is not working??