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

tamerj1's avatar
tamerj1
Community Champion
3 years ago

Denise_ 
Do you always have only two months?

If so then you can rearrange the table as follows. In this case I see no need for dimTables but of course I don't have the full picture to fully judge that.

Please refer to attached sample file and let me in case this does not comply with your requirements.

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
    Community 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