Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
If you want to exclude selection in month field than change your expression to this:
Sum({<month>} Sales)
To exclude selection in the month field you can try this:
{<Month>}
Thanks for the quick reply, but I did not understand 😞
The expression I use is = Sum ([Sales])
the dimension is month.
thanks
If you want to exclude selection in month field than change your expression to this:
Sum({<month>} Sales)
try
sum({<MonthFieldName=>}Sales)