Below is a simple representation of a huge data and its pivot table

Data

+------+------+ | Proj | Data | +------+------+ | ABC | S | | ABC | U | | ABC | S | | ABC | U | | ABC | U | | XYZ | U | | XYZ | U | | XYZ | U | | XYZ | U | | XYZ | U | +------+------+

When we apply pivot table to this data,

Coulumn Label - Proj

Row Label - Data

Value - Data

We get,

+-------+---+---+-------+ | Proj | S | U | Total | +-------+---+---+-------+ | ABC | 2 | 3 | 5 | | XYZ | | 5 | 5 | | Total | 2 | 8 | 10 | +-------+---+---+-------+

How can we show below result,

using combination of value filters and label filters on column labels

and without using row label filters (it wont be feasible as original data has too many row label)

+-------+---+---+-------+ | Proj | S | U | Total | +-------+---+---+-------+ | ABC | 2 | 3 | 5 | | Total | 2 | 3 | 5 | +-------+---+---+-------+

Thanks!