Forum Discussion
Create a Variable in a table column from a drop down list
To add to original post here's the table.
What I'm trying to do is make Precentage column a drop down so user can select 2 thru 8, but only one value. The requirement is that every line is a independant percentage of the other lines. As you see it now there is multi lines but with different precentage. That because I joined it to a second table with Squence as the key and the precentages of 2 thur 8. But that is not working like I had hoped. I'm thinking since the 2 thru 8 in constant there should be a way to set them as a fix value some how.
Then take the users selected precentage into a calculation for the field not shown "Future Cost".
From a spreadsheet view, it's the fields in RED that I'm trying to come up with in my report.
Thanks!!
Super UserHi
Is this what you want ?
if this is what you want what i did is
- just drag and drop the percentage column to a slicer
- create a matrix table
- in matrix table format visuals i made layout style as outline and switch off sub total
- changed format of the percentage column to text
This was a solution I presented to the business area, however they want it at the individual line item. The projects will be in different areas of the country so rates could be different and that's what they want to capture. In my example the different color lines are different projects and they selected different rates.
- kushanNa
Hi,
Your initial requirement is sorted now, right? In my previous comment, I provide the solution for "need help with a dropdown to select the Projected Inflation amount from within the table."?
Thanks
Sorry if my question wasn't clear or examplt. Each project can have a different rate therefore I need the ability to change it at the line item within the table.
v-menakakotaCommunity Support
Hi Anonymous ,
May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.
Thank you.