Dimension limitations

[aminqlik]

Hi All:

  Raw data table as below:

Date	Type	Count
1-Jul	A	1
1-Jul	A	1
1-Jul	B	1
1-Jul	C	1
1-Jul	E	1
2-Jul	A	1
3-Jul	B	1
4-Jul	C	1
5-Jul	A	1
6-Jul	C	1
7-Jul	D	1

When I select date, it will show the types and total test count for each date.

Expected data out:

Date	Type	Total Test Count
3-Jul	B	2

or 

Date	Type	Total Test Count
1-Jul	A	4
2-Jul	B	2
3-Jul	C	3
4-Jul	E	1

Thanks your help.

[Taoufiq_Zarra]

Can you develop more?

how you get for example :

4-Jul

E

1

[aminqlik]

Hi Taoufiq ZARRA:

   Sorry. Need to correct the second expected result.

   Should be:

Date	Type	Total Test Count
1-Jul	A	4
1-Jul	B	2
1-Jul	C	3
1-Jul	E	1

[Taoufiq_Zarra · Accepted solution]

Hi Amin,

one Solution

In dimension : Date and Type

and in expression :

=aggr(sum({1<Type=p(Type)>} Count),Type)

output :

+

or

[Kushal_Chawda]

how you get  C for 3-Jul?

3-Jul

C

3

[aminqlik]

Hi Taoufiq ZARRA:

     Thank you so much for help. The problem has fixed by your suggestion.

Regards,

Shih Min