Why would you add the same field multiple times to an aggregate query?

[chirag-garg]

One case is when you want to do some kind of conditional aggregation on the field based on multiple other columns.

A typical example is classic cross tab scenario where you want a column to be aggregated and summed based on multiple status for multiple countries

like