Forum Discussion

justinMcC's avatar
justinMcC
Frequent Visitor
8 years ago

Create a calculated table (dynamically changing data)

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

Need Help

3 Replies

  • Eric_Zhang's avatar
    Eric_Zhang
    Microsoft Employee
    8 years ago
    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's avatar
    McCow
    Resolver III
    8 years ago

    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's avatar
      justinMcC
      Frequent Visitor
      8 years ago

      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