Forum Discussion

Denise_'s avatar
Denise_
New Member
3 years ago
Solved

Filter by selected rows

Hi there, i have two charts (histograms) about the same fact table. (Fields:  Positionnumber, Month, Value). Theres also dimTable for the Positiondata (Key positionnumber) The first charts shows ...
  • tamerj1's avatar
    tamerj1
    3 years ago

    Denise_ 
    Ok, then you can create a calculated column of the next month's bins as follows

    You may select a month to analyze it along with the next month as follows

    See attached sample file

Denise_'s avatar
Denise_
New Member
3 years ago

Thank you for your efforts.

I don't always have only two months. I just wanted to make a minimal example as I can't share the original report.

I also have a chart for the next 3 months, for example, and I would like to use the filter here as well.

The dimensions are also minimized, I need them for the rest of the report.

tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
3 years ago

Denise_ 
Ok, then you can create a calculated column of the next month's bins as follows

You may select a month to analyze it along with the next month as follows

See attached sample file