Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
On main chart, I show figures according to the month, selected by the user.
On one extra chart, I want to show the total year, month by month (bar-chart). So here, the selected month shouldn't be considered.
I tried: sum({1} Sales)
It shows each month, but, if user selects other dimensions (e.g. Product, Sales Area, etc.), the bar-chart doesn't change; so other selections do not have influence on this chart.
Reinhold
Can you post sample application?
try this, bypass month field?
=sum({<Month=>} Sales)
Test-App attached.
Line-Chart should always keep displaying all months.
Hi Reinhold,
If you want to ignore the filter try
sum({<Month=>}sales)
If you need the total then sum(Total Sales)
Thanks,
Sangram
This works, when using the date-field from the original source.
It doesn't work, when using the calendar-function.
Calendar:
Declare Field Definition Tagged '$date'
Parameters
first_month_of_year = 1
Fields
Year($1) As Jahr Tagged '$year',
Month($1) As Monat Tagged '$month',
Date($1) As Datum Tagged ('$date', '$day')
Groups
Jahr, Monat, Datum type collection as JahrMonatTag;
Derive Fields From Fields Date1 Using Calendar;