is it possible to share data with dummy value or workbook?
Yes perfect! How did you do it?
2 of 2 people found this helpful
Hi Nadia Garrett,
I have used below calculations. please refer to them. Put them in columns.
IF [Gender]="Female" THEN -([Pernr])
IF [Gender]="Male" THEN ([Pernr])
Please find the .twbx attachment.
Thanks Ashish Chaudhari for help.
Thanks and regards,
1 of 1 people found this helpful
Here you are Nadia.
Single calculation required
if [Gender] = 'Male' then -1 else 1 end
now use this calculation as a sum for the visualisation
Thank you! Very helpful
Another great solution, thank you!