1 Reply Latest reply: Aug 28, 2014 7:05 AM by Ashfaq Mohammed RSS

    Pivot table

      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.

       

       

      pivot.PNG.png