Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Column not summarized

Hi, I would like to ask why the column does not summarize even tho its selected as 'Sum' already. the format is also number, when dragged into the values space, it only shows the very first day of e...
Need Help
  • Ajinkya369's avatar
    Ajinkya369
    6 years ago

    Hey Anonymous ,

     

    The date which you are using in the matrix/table(calender dimension table);It contains first day of each month.

     

    This is your date dimension table.

     

    It gives all date when you select the date from anacle table instead of calender dimension table.

    desired result,when you select date from the anacle table.

     

    If your problem is solved please accept this as solution.

     

    Thank you.

amitchandak's avatar
amitchandak
Super User
6 years ago

Anonymous , check its data type

Sum(Table[Column])

sumx(Table,Table[column]) should work

 

Can you share sample data and sample output in table format?

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi,

       

      Anyone able to help me? Is it bugged?

       

      Thanks an Regards,

      Zhide

      • Ajinkya369's avatar
        Ajinkya369
        Resolver III
        6 years ago

        Hey Anonymous ,

         

        I have opened your file please tell me on which report page you are facing problem?

         

        You can connect me through remote desktop also.I will share your the credentials in the personal message.

         

        Thank you