when you write a calculation you are adding a column to the underlying table of the viz - you will need to create a statement
similar to this superstore example
where I subbed category for your part
it returns this
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
Thank you. It works perfectly.
Glad to help out
Enjoy the weekend