Power BI Exchange

Expand all | Collapse all

How Do I Subtotal a Column

  • 1.  How Do I Subtotal a Column

    Posted 07-11-2018 05:19 PM
    I'm trying to create a sales report to show sales by division; however when I select the Sales Amount field the report populates multiple rows (one for each invoice). How do I get so the report is consolidating by division?

    ------------------------------
    Heather Joseph
    Bakery de France
    Rockville MD
    301-795-4531
    ------------------------------


  • 2.  RE: How Do I Subtotal a Column

    Silver Contributor
    Posted 07-11-2018 05:29 PM
    If it's ok, could you please post the screen-shot of the whole page (Including the rows, columns, values pannel), with what you are seeing now.
    So, that we can see what's going on.

    ------------------------------
    Yaswanth (Yash) Muthakapalle
    Greater Chicago Area, IL
    (302) 724-9274
    ------------------------------



  • 3.  RE: How Do I Subtotal a Column

    Posted 07-12-2018 09:25 AM
    I want the report to look like this: 
    But the report in PowerBI looks like this (I hide our sales numbers):
    Looks like each invoice is being listed in its own line versus summarizing by division.

    ------------------------------
    Heather Joseph
    Bakery de France
    Rockville MD
    301-795-4531
    ------------------------------



  • 4.  RE: How Do I Subtotal a Column

    Silver Contributor
    Posted 07-12-2018 09:52 AM

    If you are hiding it, why do you need it ?

    Assume this as a SQL query,

    SELECT Channel, Sales_Number, SUM(Sales_Amount) AS Sales_Amount, FROM Table GROUP BY Channel, Sales_Number

    so, you get single line for each sales Number.

    So, just by removing your Sales_Number it should give you the same way you want.



    The other option is Use Matrix visual.

    So, if you need Sales_Number for each Channel, you can drill to second level. 



    ------------------------------
    Yaswanth (Yash) Muthakapalle
    Greater Chicago Area, IL
    (302) 724-9274
    ------------------------------