Assuming the number of reports for each quarter is a measure names in the format No_Q<x>_Reports, you can try to create a calculated field (let's call it #Reports) like this:
str([No_Q1_Reports]) + "/ " + str([No_Q2_Reports) + "/" + str([No_Q3_Reports]) + "/" + str([No_Q4_Reports]
Once created, drag this calculated field into the Measures area, and then drop it in the Rows section. It should now display as AGG(#Reports). You can then place an appropriate label in front of this, like "Number of Reports received Q1/Q2/Q3/Q4 - ".
Hope this helps!
Thanks Amit. It helps.
But I have only one measure for the total number of records and I don't have count for each quarter.
Do you know how can I get the count for each quarter?
How are you getting the numbers, 10, 20, 30 and 40 in the example above? Do you have the quarter as a dimension in the dataset?
You should be able to create multiple measures, one for each quarter, using this dimension, and then use the method described above.
Also, please attach a workbook (.TWBX) file so that I could take a better look at it.
I got it. I created a separate calculated fields for each quarter and got the result.
Thanks much for your help.