Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have a pivot table in which i have calculated dimensions as
=aggr(sum({<test_fail_fdat.TT_TYPE=>}test_fail_fdat.TOTAL_FAILURES),test_fail_fdat.TT_TYPE)&'/' for FAILURE
and
=aggr(sum(TOTAL_UNITS_PROCESSED),LOCATION_DESCR,OT_TYPE) for TESTED
I need to calculate yeild % and that should be ( Failure/Tested )* 100 and it should be shown before test field
How can i calculate this in pivot table...
Please find the attached xl file which is exported from pivot table and application ..
Thanks
Sushil
Hi ,
Use the Column function to find your desired output.
for ex:.
Failure the first expression.
column(1)/column(3)*100 as % Field .
Testing the third exppression.
Good Luck
Regards,
Nitin Jain
Hi,
Just add this expression ([Failure Expression Name]) / ([TESTED Expression Name]) * 100 and move the expression to the position you wish.
I think you know we can use the Expressions in another expression.
Regards,
Jagan.
hi jagan,
thanks for your reply...
but i am not able to calculate as per your suggestion... i have added sample application... please help me to solve this..
Thanks
Hi Nitin,
Thanks for your reply.. i have added the sample application.. Please help me out to solve this issue... as i am not able to solve as per your suggesstion.
Thanks
+jagan,
the formula i am calculating as a dimension not the expression...
i have attached the application..
Thanks
Hi,
Is it possible to calculate Failure and Tested values in Script during load using Group by.
Regards,
Jagan.
+jagan
I think that would not be possible.. 😞
Regards
sushil