Hi All

Could anyone help with this problem

I have the following table

I want to calculate number of simple tasks distinct from task D as well as number of complicated tasks where simple task is distinct from D

I can simply do this by COUNT(Simple Task) and COUNT(Compl Task) both filtered with Simple task in {A,B} and I get

Worksheet 1

Simple task            COUNT(Simple Task)

A                               6

B                               2

Worksheet 2

Compl task            COUNT(Compl Task)

C                              4

L                               1

But what I want is to see both on one and the same worksheet like below

Calculation X               COUNT(Calculation X)

A                                       6

B                                       2

C                                       4

L                                        1

Is it possible within tableau not modifying the table?

Thanks in advance

Levan