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_ 
Can yu sahre a 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