How to combine rows with same information in Tableau

Question

What I have?

I have a dashboard in Tableau which shows different payments received - the amount, the date the payment was received, and a calculated field which shows the number days since the payment was received.

However, lot of payments are same, with the same amount, and received on the same day; so Tableau collapses them together, and adds the total days since the payments were received together in the final column, i.e. five lots of £5.50, each received on 1st January shows as below (as of 01/02/2018)

Column 1   Column 2     Column 3
£5.50     01/01/2018      155

What I want?

But I need separate rows for each. Does anyone know how to stop tableau doing this, or of a workaround? Many thanks.

Answer 1

@Ghost, Tableau has a function RANK_UNIQUE which you can use for this query

As a first step, uncheck the aggregate measures within the Analysis Menu.

Then, starting from this sample data:

You can get the following result: 

Additionally, if you want to hide Rank from rows -- not-showing header.

Is this something close to what you're looking for?

EDIT/UPDATE

In order to get all values and not just for the top rows, just move the Rank at the very beginning of the shelf:

Comments

I want to merge the cells of  Rows which are result of an aggregate function - where value is same for these cells.. Could you please help

WINDOW_MAX(SUM([Sales])) -- (computed using Pane down)

---

Can you provide more information on your question? (dimension/column names)

You want to group rows that have same WINDOW_MAX(SUM([Sales])) value. Am I right?