Forum Discussion

ZVV's avatar
ZVV
Frequent Visitor
8 years ago

Add Total row for table (column is not summarized)

Hi

 

I have a number column in Table report.

I don't need to Sum() this column (marked as "Don't summarize"), but I still want to see Total sum for this column.

 

I have several lines for each date with different figures and I need to see them all.

For example I have lines with 3, 5 & -7fro today. If I mark the column as "Sum" - I'll have just one line with 0.

But I need to see all the lines and have Report Total at the same time.

 

Thanks!

11 Replies

  • ZVV's avatar
    ZVV
    Frequent Visitor
    8 years ago

    So as far as I understand it's just impossible to have grand total in Table if you have "Don't summarize" numeric values?

    Can someone confirm that?

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      I also faced the same issue today, I added a card visual at the end to show totals and in tables I made as don't summarize. This overcame my problem.

  • v-caliao-msft's avatar
    v-caliao-msft
    Microsoft Employee
    8 years ago

    ZVV,

     

    You could use a  table visual to display data in your table, mark as Sum, and then turn on Total.

     

    Regards,

    Charlie Liao

    • ZVV's avatar
      ZVV
      Frequent Visitor
      8 years ago

      I mentioned in the question that I can't mark "Sum" - it must be marker as "Don't summarize".

      In this case Grans Totals do not appear regardless of "Totals" setting.

      • v-caliao-msft's avatar
        v-caliao-msft
        Microsoft Employee
        8 years ago

        ZVV,

         

        If that is the case, I am afraid there is no such a option to show total row in your table visual. Thank you for your understanding.

         

        By the way, why cannot mark it as "SUM"?

         

        Regards,

        Charlie Liao

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      This worked for me!! thank you 🙂

  • brygwalski's avatar
    brygwalski
    Regular Visitor
    3 years ago

    Hello ZVV,

    I have found the same issue with my report. My solution was to sum the column in a measure. This will allow you to get a grand total at the bottom and still keep the data split out.


  • AndresPino's avatar
    AndresPino
    New Member
    2 years ago

    Hi All,

     

    im trying to create a calculation that sum the total of the previous week into the current week 

     

    week 11 has a total of  9,884 and week 12 has total of -49229 .  As result, week 12 should Be -39,345.  Please see my chart below.

     

      

    Pull DateOld FeedstockFile TypeWK11WK12WK13WK14WK15WK16WK17WK18WK19WK20
    3/11/2024BCDMSTotal             9,884       (49,229)         202,540           5,274       (33,926)       (104,368)           45,701         (14,174)       (45,307)       (72,729)
    3/11/2024BCDMSDemand       (237,725)       (49,229)       (114,920)       (49,400)       (89,482)       (104,368)       (172,995)       (121,759)       (95,044)       (72,729)
    3/11/2024BCDMSIncoming POs           317,460         54,674         55,556          218,696         107,585         49,736 
    3/11/2024BCDMSRPM         247,609         
    3/11/2024Total             9,884       (49,229)         202,540           5,274       (33,926)       (104,368)           45,701         (14,174)       (45,307)       (72,729)
                 
               (39,345)         153,311       207,814       (28,652)       (138,294)         (58,666)           31,527       (59,482)     (118,036)

     

    this is the calculation that im using. but the formula is adding carry over all the categories. I just want the total

    Stock on-hand Total =
    CALCULATE(
        SUM(Coverage[New Qty]),
        FILTER(ALLSELECTED('Calendar_Dax'[WeekNum]),
            ISONORAFTER('Calendar_Dax'[WeekNum], MAX('Calendar_Dax'[WeekNum]), DESC))))