Hi all,
I created a report using relational package in report studio 10.2. There are three different fields(column) used to getting the reports. Each fields having budget and actual measure values then two more column in a cross table total budget and total actual. I Retrieved distinct budget values because each work having only one budget value that's why. Actual is normal working hours to complete the work. Total budget and total actual for that row level total details. Now my problem is how to calculate distinct values in budget. I'm using query like
"total( distinct ([budget]))".
I want to know is any option to retrieve distinct budget data using work_id(primary key)?
Backend is MySQL.
Please let me know is possible in report studio.
Thank you.