Hi Tim, Thanks for all your great content, il love to learn from all you video's while im still a beginner! Would you be able to show how to make calculations with values withing 1 dimension. like: Sales of chairs / sales of tables from the furnuture dimension. Hopefully my example is clear. it would help me out greatly!
Thats 3 calculations and you summarised it yourself. calc 1) if product = chairs then Sum( Sales) Calc 2) if product = table then sum(sales) calc3) calc 1 / calc 2 Watch my video on logic statements and the IF function to see how to write the if statements properly.
Thanks!
Hi Tim, Thanks for all your great content, il love to learn from all you video's while im still a beginner! Would you be able to show how to make calculations with values withing 1 dimension. like: Sales of chairs / sales of tables from the furnuture dimension. Hopefully my example is clear. it would help me out greatly!
Thats 3 calculations and you summarised it yourself.
calc 1)
if product = chairs then Sum( Sales)
Calc 2)
if product = table then sum(sales)
calc3)
calc 1 / calc 2
Watch my video on logic statements and the IF function to see how to write the if statements properly.
Find out more about the 23.3 release here: www.tableau.com/products/new-features#item-98046