Hi,
Can PowerPivot do this??
Can it PercentRank a column based on the date in Column A, and then PercentRank Column B? Rather than just ranking the whole column, it's dependent upon the value in column A.
Can any columns in PowerPivot be exported to Excel to be worked with?
(I have some crazy formula's in Excel and may find it easier if I can dynamically export data to regular Excel but keep the bulk of my data in PowerPivot?)
Thank you!
Kindly, James
Can PowerPivot do this??
Can it PercentRank a column based on the date in Column A, and then PercentRank Column B? Rather than just ranking the whole column, it's dependent upon the value in column A.
Can any columns in PowerPivot be exported to Excel to be worked with?
(I have some crazy formula's in Excel and may find it easier if I can dynamically export data to regular Excel but keep the bulk of my data in PowerPivot?)
Thank you!
Kindly, James