Forum Discussion

okusai3000's avatar
okusai3000
Helper IV
5 years ago
Solved

Wrong Subtotals Matrix

Hello everyone,   First of all, I promise you that I've been using the searchbar but I couldn't find a proper answer.   I have the following graph, and I simply cannot get a proper subtotal. For ...
Need Help
  • okusai3000's avatar
    okusai3000
    5 years ago

    AllisonKennedy ,

     

    Finally with our consultant we arrived to the solution: We had to disable the relationship bewtween the calendar table (Dim Date) and the Fact Table (Fact Stock Equipos). This allowed us to have a proper subtotal, and in order to keep things ok with the original measures, I just add USERELATIONSHIP on them.

     

    Anyway, thanks a lot for your kindness and help, 

okusai3000's avatar
okusai3000
Helper IV
5 years ago

AllisonKennedy , did you reach to read my last message? I was saying that at the end, the original formula was all right. I mean, the reason why I'm using DISTINCTCOUNT with esap_cod is because, esap_cod is the article itself (the unit), and nmap_id the category.

 

Any extra advice? 😕

 

thanks!

 

 

okusai3000's avatar
okusai3000
Helper IV
5 years ago

AllisonKennedy ,

 

Finally with our consultant we arrived to the solution: We had to disable the relationship bewtween the calendar table (Dim Date) and the Fact Table (Fact Stock Equipos). This allowed us to have a proper subtotal, and in order to keep things ok with the original measures, I just add USERELATIONSHIP on them.

 

Anyway, thanks a lot for your kindness and help, 

  • AllisonKennedy's avatar
    AllisonKennedy
    Community Champion
    5 years ago
    Yay! Glad it's working now and thanks for the update - sorry it has been a busy week. Please mark your own reply as a solution so people with a similar problem can benefit from it. 🙂