Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

RANKX function is not working

I have a simple table from Google Analytics that look at website pageviews for a online news site. The table (Views) consist of the following columns: "Category" "screenPageViews" "pageTitle" "da...
General Comment
isjoycewang's avatar
isjoycewang
Solution Supplier
2 years ago

Hi Anonymous,

 

I create some dummy data for demo: Exercise File

Please consider that there is also 'Category' column in your second table.

RankArt = 
IF( HASONEVALUE(Views[Category]),
RANKX( ALL(Views[pageTitle],Views[Category]),  CALCULATE(SUM(Views[screenPageViews])),,DESC), "")