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
Icon for Community Champion rankCommunity 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.