Hi everyone,
I am trying to build a dashboard based on the dummy file attached. As I understand, this is most likely done with PowerPivot, but I am not familiar enough with excel to use PowerPivot to that extent. Anyhow, I would basically like to build a tool, which takes a number and add an additional number based on different criteria. The two numbers are on two different sheets, which really troubles me.
In the dummy-file on 'Sheet 1', I would like separate slicers – or another option with buttons – with “Category” and “Type”, which shows the “Price (number)” for the clicked off item. I would like a third slicer but the data is on 'Sheet 2' where I would like a slicer for “Grown in” and a tap (or two taps – e.g. ‘Florida’ and ‘Local farm’) is clicked on, the “Additional cost (number)” must be added to “Price”.
The difficulty for me is to how to get 3 slicers in one sheet when the raw data is on teo different sheets along with how to add the two numbers based on the clicks.
Lastly, I would very much like a relation from the above to “Best before” so when a button is clicked the “Best before” is displayed somewhere on the dashboard.
I hope this makes sense!
Best,
Ida
I am trying to build a dashboard based on the dummy file attached. As I understand, this is most likely done with PowerPivot, but I am not familiar enough with excel to use PowerPivot to that extent. Anyhow, I would basically like to build a tool, which takes a number and add an additional number based on different criteria. The two numbers are on two different sheets, which really troubles me.
In the dummy-file on 'Sheet 1', I would like separate slicers – or another option with buttons – with “Category” and “Type”, which shows the “Price (number)” for the clicked off item. I would like a third slicer but the data is on 'Sheet 2' where I would like a slicer for “Grown in” and a tap (or two taps – e.g. ‘Florida’ and ‘Local farm’) is clicked on, the “Additional cost (number)” must be added to “Price”.
The difficulty for me is to how to get 3 slicers in one sheet when the raw data is on teo different sheets along with how to add the two numbers based on the clicks.
Lastly, I would very much like a relation from the above to “Best before” so when a button is clicked the “Best before” is displayed somewhere on the dashboard.
I hope this makes sense!
Best,
Ida