Pivot table

[#1]

Hi guys

This screenshot is of pivot chart which i made, although its half but i hope it ll be clear once i give detailed description.

Ive check-boxed the "always fully expanded" so im facing a weird problem, however i tried with un-checking the option but i guess its built in function of pivot table to expand it to its core. Anyway, i was wondering if there was any expression or option through which i could solve this problem. I want no repetition of Milestones[In yellow box] i want it to show distinctly rather than for every planned submit date. and same is for Employees Deployed.

The expression of employees deployed is count(Employees Deployed) but whenever i add distinct to it it doesn't show up anything.

[ashfaq_haseeb]

Hi,

This works as expected.

If you want to remove yellow repeated content. Remove Date from your from your pivot table.

Regards

ASHFAQ