开发者

Pivot tables without aggregation?

开发者 https://www.devze.com 2023-01-10 05:24 出处:网络
I have a list of items - each item has a title, plus a bunch of attributes, including a date. If I drop the date into the row box of a pivot table, then group it, and drop the title below - so I have

I have a list of items - each item has a title, plus a bunch of attributes, including a date.

If I drop the date into the row box of a pivot table, then group it, and drop the title below - so I have Years, Quarters, Created On, Title, I get a nice list of all the titles in my data, grouped by year, quarter and month.

But I want to also display all the other attributes next to the title of each one - all the associated data for each row. With the textural ones, I don't want to count th开发者_StackOverflowem - I just want to list the entire data set, but grouped by date. If I add them to the other pivot table boxes it starts doing the usual counting...

It would be nice to have all the extra filtering power of pivot tables, but am I making this too hard?

Thanks for your help.


To display text data, you will need to use the data label feature. Non pivotable text aggregation is easily accomplished in M code in power query One of my posts.

Pivot tables without aggregation?

0

精彩评论

暂无评论...
验证码 换一张
取 消