Count in Pivot table.

[Anonymous]

Hi,

I have a scenario where i want my pivot table to show count as shown in the pic.

Date:

ID	Name	Month	flag
1	q	Jan	1
2	a	Jan	1
3	z	Jan	0
4	x	Jan	1
1	q	Feb	1
2	a	Feb	0
3	z	Feb	0
4	x	Feb	1
1	q	Mar	1
2	a	Mar	0
3	z	Mar	0
4	x	Mar	0

I am putting a green check image where ever flag=1 and i count i want to count number of flags for each month. I am pivoting the table on Month column.

[Kushal_Chawda · Accepted solution]

Expression:

=if(Dimensionality()=0,Sum(flag), if(sum(flag)=1,'qmem://<bundled>/BuiltIn/check_g.png'))

[antoniotiman]

Hi,

see Attachment.

Regards,

Antonio