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?
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.
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
Building 1 Subtotal
Building 2 Customer 3
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.