Sumo Subtotals not appearing correctly

user01003
user01003
in Archive

I have two categories in my rows: Building and Customer and I can't get the SUMO card to get subtotals by only Building. In some rows, it displays subtotals by Customer and in others, by Building.

 

Any idea on how to fix this?

Comments

  • Data_Warrior
    Data_Warrior

    Are Building and Customer in the same series?  If so, drag that series to Categories section  in the edit view (click the pencil on the left) and filter the series to just building.

    All the best!
  • user01003
    user01003

    No, they are not in the same series. They are two different series. What I'm trying to do is getvalues for each building broken down by customer and subtotals for each building (the first seies).

     

    Building 1             Customer 1                    

                                 Customer 2

    Building 1 Subtotal

    Building 2             Customer 3

                                 Customer 1

    Building 1 Subtotal

    Grand Total

     

    This is the format I'm trying to achieve in SUMO card, but the subtotals randomly appear for some Building only, not for all Buildings.

This discussion has been closed.

Categories