I have a Data that has rows with Supplier names and to amounts spent per month with that Supplier.
For instance I have Raw Data Like :
(Row 1) = Megan services $ 500
(Row 2) = MOP Services $ 480
(Row 3) = Megan Co Services $ 460
(Row 4) = MOP info Services $800
(Row 5) = Megan services IND $4,000
(Row 6) = Rosy Info Services $600
The result would look like this:
(Row 1) = Megan services $4,960
(Row 2) = MOP Services $1280
(Row 3) = Rosy Info Services $600
By Grouping we can achieve above one.
But Problem is Data will refresh Weekly basis, So in original data might be add new row like "Megan Info Services $700",so Now Megan Services should show $4960+700=$1160.
Which means whenever new row added in data with new name should be automatically update with existing group.
For that need to create any calculated field ?
Is possible in tableau ?