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.