I am having a table rows such as postID and subjectIS as primary key in the table,some has subject level and post level measures
+---------+-------------+--------------+------------+--------------+--------+
| post.ID | post.Author | post.Replies | subject.ID | subject.Rank | year |
+---------+-------------+--------------+------------+--------------+--------+
| 1 | mike | 10 | movie | 4 | 1990 |
| 1 | mike | 10 | comics | 6 | 1990 |
| 2 | sarah | 0 | tv | 10 | 2001 |
| 3 | tom | 4 | tv | 10 | 2003 |
| 3 | tom | 4 | comics | 6 | 2003 |
| 4 | mike | 1 | movie | 4 | 2008 |
+---------+-------------+--------------+------------+--------------+--------+
Putting measures like COUNTD(post.ID) and COUNTD(subject.ID) in rows and 'year' in column
And i want to drag MEDIAN(subject.Rank) in Color,and I am not getting a proper result
How can I improve it