Forum Discussion
Digger
Post Patron
Post PatronSum by months
For example i have Excel file (link to file)
How can i get matix like
Which sum selected month excel table?
Ofcourse measure should be dinamic, as there will bee a lot of years
Digger , check if the attached file after signature can help
3 Replies
- amitchandak
Super User
Digger , Unpivot all the month columns and then you should be able to aggregate
Diggeramitchandak which one? there are two months columns, and this is not work, as matrix sum all months, i need only last
Now i getinstead of
- amitchandak
Digger , check if the attached file after signature can help