Forum Discussion

axel_BI's avatar
axel_BI
Helper I
6 years ago
Solved

Pivoting Data with a measure

Hi, my data is presenting me the sales per article per day per location. Like this. Location|Date|Article_Nr|Sales 1000 05.08.2019 100                                                       4...
Need Help
  • Piotraq's avatar
    Piotraq
    6 years ago

    You can use summarize:

     

    Summarize(Table;

    Table[Location];
    Table[Date];

    "Sum";Sum(Sales);
    "AVG";average(Sales))

     

Piotraq's avatar
Piotraq
Frequent Visitor
6 years ago

You can use summarize:

 

Summarize(Table;

Table[Location];
Table[Date];

"Sum";Sum(Sales);
"AVG";average(Sales))

 

  • axel_BI's avatar
    axel_BI
    Helper I
    6 years ago

    Thank You,

     

    the pivot-table works just fine