Hello, I am creating a 3D bar chart that shows objects (Pens, Pencils, Binders) by total QTY. I have created a slider that will increase or decrease (by a percentage) the QTY of the objects but is there a way I can create a slider for each object to change its QTY separately? Let me know if that is possible and what direction I should go in. Thanks!
This need is not a good practice because you want to treat content of the same dimension differently.
But if you want to insist on the idea, what needs to be done is to "slice" the content of the dimension and for each type of content you call it independently, as if it were outside the dimension.
Create one variable for each content and associate to a slider. Example: vPens, vPencils, vBinders
Formula:
=Pick(Match(YOURFIELD, 'Pens', 'Pencils', 'Binders')+1, Sum(QTY), // Match Position 0 (Exception or Others) Sum(QTY) * vPens, // Match Position 1 (Pens) Sum(QTY) * vPencils, // Match Position 2 (Pencils) Sum(QTY) * vBinders) // Match Position 3 (Binders)
Support your colleagues. Remember to "like" the answers that are helpful to you and flag as "solved" the one that helped you solve. Cheers.
