Forum Discussion

Sab's avatar
Sab
Helper V
7 years ago

Help with Pivoting needed

Hello,   I have a license log file, which among other columns, has Date and Status coulmns, see attached.    When I pivot these and I choose to not Aggregate I get the error: "Expression.Erro...
Need Help
AkhilAshok's avatar
AkhilAshok
Solution Sage
7 years ago

How did you apply pivot? You have to first click on the Status column, select Transform->Pivot Column, give Values as Date and Aggregate as Don't Aggregate. This should ideally work.

Sab's avatar
Sab
Helper V
7 years ago

Thanks for your reply. I know how to Pivot (just like your steps), but as I explained it returns an error. 

  • AkhilAshok's avatar
    AkhilAshok
    Solution Sage
    7 years ago

    Can you post a sample dataset which gives this error?

    • Sab's avatar
      Sab
      Helper V
      7 years ago

      Here:

       

      https://sabedin-my.sharepoint.com/:x:/g/personal/sabedin_bidatalab_com/EQhzCrCwjaZMlJ312apfOtUBFUMiCdPH0HRrXqx0GP7xKw?e=i3B7J6

       

      Let me know if you don't see the file

      • Ashish_Mathur's avatar
        Ashish_Mathur
        Super User
        7 years ago

        Hi,

         

        There are multiple IN and OUT on each date.  For 10 Sep and 13 Sep, please show the exact result you are expecting.