Hello,
I've excel file (as greyed below) and I want to show 4 calculated fields (CF) as (red highlighted) for 4 "Team" as highlighted in yellow. Output is green highlighted.
Problem Faced:
(1) Not able to find right solution for CFs - Forecast and GAP.
(2) How to represent ONLY (# of Sales) monthwise but display all 4 CFs at QUARTER levels as shown in the green above.
FYI - CF "Target" is a fixed number.
Can someone please help, as I've tried multiple workarounds but couldn't find solution?
My twbx file is attached containing all CFs and tableau ver. is 2020.1. Also attaching excel file containing table & calculations (as shown in the image)
HI, Nikesh
Please find my solution by union your data to itself attached.
Below is the steps for your reference.
Hope this helps
ZZ
