Forum Discussion

paris's avatar
paris
Helper V
7 years ago
Solved

Relationship problem

Hi all,   I have forecast and actual data in diffenet format and want to combine in report format.  I can not change forecast from monthly basis to daily basis. Could you please help me to set up ...
Need Help
  • paris's avatar
    paris
    7 years ago

    Hi Zoe,

     

    Thank you for sending me the demo file.

     

    1) Is there any reason actual is under calender?

    2) I use slicer to select by country or city. 

    3) However..   I set up relationships (same as yours) but it seems not working. I got total value (sum of paris, london, tokyo) for each day. Is there any possible reason causing this problem? 

     

    All the best,

    LoveParis

     

paris's avatar
paris
Helper V
7 years ago

Hi Zoe,

 

Thank you for sending me the demo file.

 

1) Is there any reason actual is under calender?

2) I use slicer to select by country or city. 

3) However..   I set up relationships (same as yours) but it seems not working. I got total value (sum of paris, london, tokyo) for each day. Is there any possible reason causing this problem? 

 

All the best,

LoveParis

 

paris's avatar
paris
Helper V
7 years ago

Zoe,

 

Thank you very much for your help. I was able to solve my problem (it was caused because I did not set up many to many relation ship for both fact tables)

 

Thank you again!

 

All the best

LoveParis