Drill up Drill down vs Drill thorugh

[cogcurious]

I have a requirement where my report has Country and the Sales in those countries. If i click on the country then first column should show all regions under that country and the corresponding sales numbers. Should i use drill though or Drill up & down. What are the pros and cons

[jmills]

Depending on your data source, this could be simple to implement, or more complex.

If your data is dimensional (resides in a cube), then Drill Up/down would be the obvious choice.

If your data is relational, it's harder to mock the funtionality of a drill report, however can be done via drill through.

The real difference is that drill through links to another report or child report, whereas drill up/down is inherent on the same report.