Hello Guys
I need advises guys
example: I have one table called "FS_DPK_Rank"
Here is the table looks like:
and the Report will like this:
where Balance Amount will SUM per Product and TOP 2 is as TopN per CIF NO (globally TopN)
but there is condition: when user choose Office then function TopN will adjust per Office.
I'm really confused how to solve this situation.really need suggestions, advises, and solutions.with respectfully