Display Aggregated Count per Week on a Table Chart

Mon, 08 May 2017 03:17:55 GMT

Hi, I would like to ask if it's possible to create a table chart that aggregates the count of an equipment per classification on a weekly basis.

Supposedly I have a table with the following data:

Equipment, Classification, Week

Equip_1, Class_1, 201701

Equip_2, Class_1, 201701

Equip_3, Class_2, 201701

Equip_4, Class_4, 201701

Equip_5, Class_2, 201701

Equip_1, Class_2, 201702

Equip_2, Class_1, 201702

Equip_3, Class_2, 201702

Equip_4, Class_4, 201702

Equip_5, Class_3, 201702

I want to display this in a table chart like this:

Thanks in advance!

Re: Display Aggregated Count per Week on a Table Chart

tresB — Mon, 08 May 2017 07:20:39 GMT

Like this?

Anil_Babu_Samineni — Mon, 08 May 2017 07:22:53 GMT

Use, Pivot table with the expression of Count(Equipment) and Dim as Classification & Week. Then transpose to Row for Week