Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Matrix: Missing Values

I am having an issue with the Matrix visual where the sub-total shows an amount but when you drill down, there are no values showing.     Any help is appreciated, thank you very much.
Need Help
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Unfortunately, there are no filters in the visual.  This is driving me nuts and I just know that the solution is going to be the simplest thing.

 

rafaelmpsantos's avatar
rafaelmpsantos
Responsive Resident
7 years ago

Create a simple table with tree columns Mealtime, ProfitCenter and Sales and show us

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Thanks for taking the time rafaelmpsantos, I really appreciate it.

     

    • rafaelmpsantos's avatar
      rafaelmpsantos
      Responsive Resident
      7 years ago

      I really can't see what is causing this problem.

      Sales is a measure or a columns? if a column try change it for a measure like sum(sales)

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        Sales is a column.  I tried it as a measure but it is still blank.

         

        What is weird is when I uncheck "Show items with no data", they show up just fine.

         

        I really don't want to go that route, but it looks like it is the only solution for now.

         

         

        Thanks again for the time rafaelmpsantos.