Hi,
I want to filter top 10 values in for two entries in row items in pivot. for eg
[TABLE="width: 182"]
<tbody>[TR]
[TD]1 (Week)[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]x (Value in Week)[/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD]y[/TD]
[TD="align: right"]3[/TD]
[/TR]
[TR]
[TD]z[/TD]
[TD="align: right"]4[/TD]
[/TR]
[TR]
[TD]2(Week)[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]x[/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD]y[/TD]
[TD="align: right"]3[/TD]
[/TR]
[TR]
[TD]z[/TD]
[TD="align: right"]4[/TD]
[/TR]
</tbody>[/TABLE]
So, i want to sort on week and then want to show the top 10 values for all entries in that week (there are multiple entries) and if possible i would like to get the common values separately which are common for all the weeks.
I used the topn function but is not working for me . Please help power pivot experts!
I want to filter top 10 values in for two entries in row items in pivot. for eg
[TABLE="width: 182"]
<tbody>[TR]
[TD]1 (Week)[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]x (Value in Week)[/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD]y[/TD]
[TD="align: right"]3[/TD]
[/TR]
[TR]
[TD]z[/TD]
[TD="align: right"]4[/TD]
[/TR]
[TR]
[TD]2(Week)[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]x[/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD]y[/TD]
[TD="align: right"]3[/TD]
[/TR]
[TR]
[TD]z[/TD]
[TD="align: right"]4[/TD]
[/TR]
</tbody>[/TABLE]
So, i want to sort on week and then want to show the top 10 values for all entries in that week (there are multiple entries) and if possible i would like to get the common values separately which are common for all the weeks.
I used the topn function but is not working for me . Please help power pivot experts!