fictive
1 Topic
Create a slicer for a fictive price point
Hi all, Hope you can help me find a solution for the following: Background: I have a dataset that looks like the table below. I match the price of my article with the prices of my competitors. I can then see the impact ($ difference) with the number of sales and the difference between my and my competitors pricing. Article My price Competitor Competitor Price Difference Sold items $ difference Bread $1,00 Supermarket 1 $1,10 0,10 25 2,50 Bread $1,00 Supermarket 2 $1,00 0 25 0 Bread $1,00 Supermarket 3 $0,80 -0,20 25 -5,00 The total diffence for Bread is -$2,50 (2,50 + 0 + -5,00) at my current price point of $1,00. Question: I want to make a slider that makes a fictive price for the column 'My Price' to see how this would change my $ difference. So for example, if I make my price of bread to $0,95, how much would be $ difference be? Is there a way of making a fictive variable that I can put in a slicer? Hope someone has a helpful tip for this 🙂 Thanks in advance!Solved661Views0likes4Comments