Forum Discussion
Using filters to change value/column in view
Guys, I want to work with a report that contains 2 values: quantity sold and income. But I wish I could show them on the same line graph, and individually (by filter control) also in the same l...
v-caliao-msft
Microsoft Employee
Microsoft EmployeeHi Michell,
I have tested you solutoin which wokrs fine. And actually you do not need to reconstruct the table, you can use a query like below.
select a.Date as [Date],a.Detail as [Detail],'Sales' as [KPI],a.Sales as [Value]
from
[dbo].[Test1] as a
union all
select a.Date as [Date],a.Detail as [Detail],'Qty' as [KPI],a.Qty as [Value]
from
[dbo].[Test1] as a
Or you can create view use that query, and use the view as the data source.
Regards,
Charlie Liao
I will start testing it soon, and will return to you, my friend.
Thanks!