2 of 2 people found this helpful
Hi @Ce Lin
Here is the solution attached. Now the steps to achieve this :-
Step 1. Create a calculated Field
IF [3+ years]='yes' THEN 1
Step 2. Drag below measures to the Text shelf
Number of Records
Step 3. Click on the Text tab marked yellow and put this code----> <SUM(_Employee(3+) )>/<SUM(Number of Records)>
Step 4. Go to Analysis on the top menu bar---->Totals---->Show Column Grand Total.
Please make sure to commit this thread as correct if this is what you required or else if you still face some issue in that case let me know.
That answers the question if I'm only looking to use the one measure on the table. However, when I add additional measures (say sales) it reverts and I can't edit it again to the same format. Can you help with that?