Create a calculated table (dynamically changing data)

[justinMcC]

Hi 

I have an enhancement request for an existing report. The end user would like to be able to select products from an existing list and set the dosage for each product on the front end report

I can set on the back end on data import however the end user want to be able to change the dosage values. Below is a sample of the data:

PRODUCTID        DOSAGE

Product 1            0.9

Product 2            0.8

Product 3            1.0

The dosage values range from 0.1 to 1.0. 

Is it possible on the front end report to allow the user to select each product and change the dosage as they wish and save the changes, eg using a calculated table 

Any help you could give would be much appreciated

Thanks 

@justinMcC

[Eric_Zhang]

---

@justinMcC wrote:

Hi 

I have an enhancement request for an existing report. The end user would like to be able to select products from an existing list and set the dosage for each product on the front end report

I can set on the back end on data import however the end user want to be able to change the dosage values. Below is a sample of the data:

PRODUCTID        DOSAGE

Product 1            0.9

Product 2            0.8

Product 3            1.0

The dosage values range from 0.1 to 1.0. 

Is it possible on the front end report to allow the user to select each product and change the dosage as they wish and save the changes, eg using a calculated table 

Any help you could give would be much appreciated

Thanks 

@justinMcC

---

@justinMcC

The only approach to save slicer changes is using Bookmarks. You may create two slicers, one for product, another for dosage maybe with What-If parameter.

[McCow]

Hi @justinMcC

do you have only 3 products? If a product count is relatively small (up to for ex. 10) is a simplest way IMHO to build independent DOSAGE slicer for every Product.

Example:

Best reagrds

[justinMcC]

Hi @McCow

Unfortunately the list isn't static, the data comes 'direct query' from a SQL query so the list of products can change over time when the data is refreshed. At the moment its 10 products, next week it could be 30 products

As the list of products changes, I need some way for the end user to be able to select each individual product and set the dosage. At the moment I am using slicer to allow user to select a product and a drowndown to select the dosage. This works OK for 1 product however I need a more scalable solution

Thanks for any help you can provide