June 9, 2016 at 4:27 pm
Hello,
Having a bit of a problem. In a single report, I have 5 dials with 5 different measures mapped on them. I want these all to roll-up to one total measure based on whether the measures are red, yellow or green.. I already have the formula I want to use.
I want to roll-up measure to be the 5-star indicator. I inserted the formula into the Value of the 5-star indicator, but it says DataSetName is not selected. That's just the thing - the Value is not coming from a Data Set, but rather the formula which is combining the 5 measures in a weighted manner. The measures come from 5 different datasets.
What are my options here? Can I combine the 5 measures into one Dataset once they're brought into the report, and then assign that Dataset to the 5-star indicator? Sorry for any confusion.
EDIT: Brand new to SSRS and just realized that it's not actually 5 stars, but 1 star split into 5 parts... wish there was a solution with 5 stars.
Viewing 0 posts
You must be logged in to reply to this topic. Login to reply