What "Create Set Based on Row Item" is used for

[INN]

Hi
I added a table to Power Pivot data model and now when I go to Pivot table Analyze, I see 2 options are active

1) Create Set Based on Row Item
2) Create Set Based on Col Item

What are these for?

Thank you very much.

 

[Matt Allington]

They are used to create asynchronous tables. Eg, you can put calendar year on columns, and budget and also sales in values, and product on rows. Creatw a set based on columns and you can remove the budget for prior years and only keep it for the current year.