Create a Pie Chart from single row, multiple column dataset in SSRS
I'd like to create a pie chart from a dataset that returns a single row with multiple columns in SSRS. Is this even possible?
I've tried unpivoting the data so I can have multiple rows, and I can't quite pull it. It seems I can't unpivot aggregated data.
So I'm not sure what my next step is. Should I try to unpivot the data, or can I build an expression for the values in the pie chart?
Here's sample data:
ID | IndivMonthSales | IndivBudget | IndivDifference
PAW $30,456.31 $60,000.00 $29543.69
The result I'm looking for is the Pie chart to use the values from IndivMonthSales and IndivDifference (which add up to 100%)
I guess there's 2 questions:
- is it possible to unpivot aggregated data (if so, how?)
- is it possible to use expressions for Pie Chart values (if so, how?)
I'm very grateful for any and all help.
Cheers!
Dave
Solution
I believe what you are asking for can be very simply solved by placing both measurements as values in the pie wizard:
Resulting in :
- Using where clause in Sql Server LEAD
- Combine overlapping date ranges
- Providing string variable into Dynamic SQL SELECT statement WITHOUT it being read as a column name?
- How to store geocoded address information into the database
- Truncate a DDL or DML command
- How can I find out what FOREIGN KEY constraint references a table in SQL Server?
- Why ISDATE() is returning 9996 as date?
- .NET 8 & SQL Server 2016 - Contains() throws error
- IsDate Function in SQL evaluates invalid dates as valid
- SQL Server - Value passes ISDATE() but fails to CAST as DATE or DATETIME
- Error when connecting to SQL Server in deno: 'cannot find module crypto'
- Multiple many-to-many and multiple one-to-one relationships in the same entities
- SQL Server DATEDIFF round up the YEAR difference. How to round it down?
- Path table to HTML treeview in SQL Server
- SUM and Decimal precision
- Parse TEXT datatype column to grab values based on TAGS
- How can I create a tar file in memory from several varbinary(max) columns stored in SQL Server using .NET native API?
- collation conflict between "Hebrew_CI_AS" and "SQL_Latin1_General_CP1_CI_AS"
- Maintaining property order with get-member
- migrate data from MS SQL to PostgreSQL?
- Add multiple conditional values to one column
- Read Committed vs Read Uncommitted if both transactions do not rollback
- SQL YEAR(GETDATE())
- VIEW with NOLOCK but called without NOLOCK
- SQL Merge WHEN NOT MATCHED BY SOURCE THEN on filtered source and targed tables
- SQL obtain timestamps for end datetime row 1 and start timestamp row 2
- Tricky SQL update
- Remove Identity from a column in a table
- Return 1 if value is 0 without CASE statement
- Append string text based on pattern search SQL