Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I have a table which consists of 2 expressions Actual Cost and Revenue.
Issue is Actual Cost value appears correctly only when date field Project Start Month is used as dimension while Revenue value appears correctly when CALDATE is used as dimension.
I want to show both expressions in a single table but both should work as per their respective date field.
I cannot use both the dimensions together.
Is there way to show correct values in above situation in a single table only?
Any way to solve this?
Tried using canonical dates but didnt work.
Attaching model