November 13, 2015 at 10:01 am
Hi everyone
I have the following matrix report in SSRS containing the following data
StoreSalesStaff
North 357 5
East 568 4
South 475 1
West 147 2
Total 1,547 12
I would like to add a tesxtbox in the header which finds the max sales from the table but rather than showing the actual number of sales ie 568. I would like it to showe the actual store which had the most sales ie East.
This is driving me crazy!
Any help would be really appreciated!!
BO
November 13, 2015 at 2:21 pm
There is no direct or obvious methodology for that kind of thing. You need to derive that data in the query that is used to create your data source. Just getting that value may be complex, depending on how complicated your query is that derives the numbers you're already seeing. You'll have to provide a lot more detail for us to have any shot at helping you create that query.
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply