Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
pivot table if i dont want a avg value for a field which is round marked
You need to use a straight table to implement this.
You want to change the Total.
Please provide a sample or explain in more words what dimension and expression you are using.
yaa its all created in pivot but i dont want averages for percentages for target % and passrate at total field only.
here i should want like this that target % value is nulll and i want passrate also kept null(
You can check the value of you dimension - if it is null then it is on the total line. See attached example.
can u please give me u r mailid
i wanna talk to u ..plsss its urgent