exclude selection

[warrentk80]

Hello everyone, I created a dashboard where the opening of the page displays the data of the last month available (thus opening the document I select the first division) and it may object selection to select the previous months.

the same dashboard I made a chart where I have to represent the sum of sales for all months of the year, but the chart being the selection of the active month shows me only a month.

as a rule the selection of the month in the chart?

Thanks for collaboration

Andrea

[sunny_talwar]

To exclude selection in the month field you can try this:

{<Month>}

[warrentk80]

Thanks for the quick reply, but I did not understand 😞

The expression I use is = Sum ([Sales])

the dimension is month.

thanks

[sunny_talwar · Accepted solution]

If you want to exclude selection in month field than change your expression to this:

Sum({<month>} Sales)

[manojkulkarni]

try

sum({<MonthFieldName=>}Sales)