Hello, I´ve recently started discovering Power Pivot and I´ve found myself with a block. One sheet has dates and items, and the other one has the items with it´s brand. What I want to know is, in each month, how many brands are there.
Whenever I try to obtain this data it asks for a new conection between the sheets and when I put the date in the rows field and the brand in the value field, and it doesn´t show me the correct numbers.
Edit: I've posted the file having corrected one header and turned the ranges into tables. Still the same error and it won't work.
Bookmarks