How to create 4 straight table charts that seperate stores into quartiles based on GP%

[william_wright]

Can I use the dimension limitation function to create 4 seperate straight table charts ranking stores based on their GP%'s with each straight table containing 16 stores? The first table would include highed 16, next would include 17-32, the next would include 33-48, and the last would include the bottom 16.

[william_wright]

Sorry, I'm having trouble uploading anything here.

This is what I've entered into the expression editor:

sum({<A277_DEAL_LOCN={"=rank(sum({<A277_DEAL_LOCN>}vGPYTD),A277_DEAL_LOCN)<=16"}>}vGPYTD)

This is the variable that I created as vGPYTD:

(Sum({$<A027_DESIGNATION={"N"},A028_STATUS={"FS"},CFD_BMT_TYPE={"B"},A222_LOT_LOCN-={"DFS","NFS",105},A063_GL_POST_DATE.autoCalendar.YearQuarter={"2017-Q4","2018-Q1","2018-Q2","2018-Q3"}>}[ECALC_UNIT_REVENUE]) -Sum({$<A027_DESIGNATION={"N"},A028_STATUS={"FS"},CFD_BMT_TYPE={"B"},A222_LOT_LOCN-={"DFS","NFS",105},A063_GL_POST_DATE.autoCalendar.YearQuarter={"2017-Q4","2018-Q1","2018-Q2","2018-Q3"}>}[A092_TOT_COST])) / Sum({$<A027_DESIGNATION={"N"},A028_STATUS={"FS"},CFD_BMT_TYPE={"B"},A222_LOT_LOCN-={"DFS","NFS",105},A063_GL_POST_DATE.autoCalendar.YearQuarter={"2017-Q4","2018-Q1","2018-Q2","2018-Q3"}>}[ECALC_UNIT_REVENUE])

The variable works fine if I put it into the expression editor as $(vGPYTD)

Could the variable I created be what is causing the data not to load?

Should it have a different syntax in the function you provided?