Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a unique requirement where I need to create a new column with Sum and Average of numbers.
For ex:
Table A
Field1 Field2 Site1 Site2 Total/Average
Actual Actual
Quality Good 10 20 30(Sum of numbers)
Quality Bad 5 10 15(Sum of numbers)
Service Good 90% 80% 85% (average of percentages)
Service Bad 10% 50% 30%(average of percentages)
Field1 , Field2 and Site are Dimensions, and Actual is expression.
Let me know if you need any clarification on requirements.
Thanks a lot in advance.
PFA.
Thanks,
Ram
Hi Ram,
Thanks for your reply. I didn't mention the actual data before. This is how data is.
Above presentation is how I want it to appear.
Thanks
PFA.
Thanks,
Ram
Hi Ram,
Thanks for your reply.. it solved my problem. Cheers