Pivot table issue ASAP

[#1]

PFA

i dont want the values as mentioned in the screen but am getting the values because of formula.

i dont want values for target % for where group is Total

[ashfaq_haseeb]

Try like this

LOAD Group,

     Passed,

     Failed,

     if(isnum(Target%),Target%,'') as Target%,

     if(isnum(passed%),passed%,'') as passed%

FROM Table

Regards

ASHFAQ

[perumal_41]

Hi Venu

Try like below expression

if (Dimensionality ()=0,'NoData',target %)

[#4]

Hi perumal

Can u please  elobrate

[perumal_41]

Hi Venu

In expression tab put below code

if (Dimensionality ()=0,'NoData',target % calculation expression )