show monthly figures, while a single month is selected

[reinholdgraf]

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

[MK_QSL]

Can you post sample application?

[Anonymous]

try this, bypass month field?

=sum({<Month=>} Sales)

[reinholdgraf]

Test-App attached.

Line-Chart should always keep displaying all months.

[reddy-s]

Hi Reinhold,

If you want to ignore the filter try

sum({<Month=>}sales)

If you need the total then sum(Total Sales)

Thanks,

Sangram

[reinholdgraf]

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;