We use "Partition" option to divide the result into multiple parts. ( It is equivalent to ADDRESSING & PARTITIION in tableau)
Let me take an example of creating Ranks.
Imagine, There are three Fields like Country, State, Sales. And want to create ranks Based up on Sates Sales Volume.
If you don't use Partition to create Ranks, it will calculate for all states irrespective of Country.
If you implement Partition on Country, Ranks will be created separately for each country.
I should add to Kumar's response, these types of partitioning and addressing calcs are usually reached by creating a window calc, a straight-out example will be:
- Drag Region to Columns
- Product Sub-Category to Rows
- Sales to text
- Create a calc: Window_Sum(Sum([Sales)) and double-click to your table
- Without adjusting any calc, this should default to Table Across and provide the total sum across all-regions for each Product Sub-Category
This has partitioned Over each Sub-Category, notice how your window calc has a delta symbol indicating that it is a table calc?
Now, right-click the window-calc pill, hover-over Compute Using and select Product Sub-Category, notice how the value for the window sum for each of your regions is the same on each row? This is the sum of sales over Product Sub-Category and region or rather:
Sum([Sales) Over (Partition By [Product Sub-Category], [Region]) It is possible to set an order by from the advanced menu if this too is required: Right-click the pill, select Edit Table Calculation From Compute Using select Advanced and then Setup the partitioning and addressing fields followed by the sort option.
I hope this helps