I have the below table with me and expecting a pie chart with legends and values as given below in another table.
I have Unique Sales ID with Order Qty and other fields.
NET Price should be given as Tool Tip.
I do not want many measures to be made as per the status or defect reasons, since the defect reasons may increase frequently.
Go to Solution.
Hi @Anonymous ,
Similar to the previous formula.
Refer to the sample.
Best Regards,LiangIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
View solution in original post
@Anonymous , You can create qty column like
Qty = Switch( True(),[Status] = "completed" , [Completed Qty],[Status] = "In Progess" && isblank([Defect Reason]) , [In Progress Qty],[Defect Qty])
Same way you can add Price column
Proud to be a Super User!
You have given the formula to get Qty, how are we going to handle the legends which is two columns ?
Check out new user group experience and if you are a leader please create your group!
Check out how to claim yours today!
Test your skills now with the Cloud Skills Challenge.