Step:1
=====
Create a New Region.
Type: Cards
SQL Query:
SELECT
1 SL,
'https://thumbs.dreamstime.com/b/colorful.jpg' ICON,
'Total Sell' TITEL,
'TK.'||TO_CHAR(SUM(PAID),'99,99,99,999')||'/-' TOTAL,
APEX_PAGE.GET_URL (P_PAGE=>25) URL
FROM ANIMALS_SELL_MASTER
UNION
SELECT
1 SL,
'https://cdn-icons-png.flaticon.com/512/9165/9165687.png' ICON,
'Total Expanse' TITEL,
'TK.'||TO_CHAR(SUM(TOTAL_AMOUNT),'99,99,99,999')||'/-' TOTAL ,
APEX_PAGE.GET_URL (P_PAGE=>11) URL
FROM EXPENSE_MASTER
UNION
.
.
.
Step:2
=====
Go to Region Attributes
Primary Key Column 1: SL
Title-->Column: TOTAL
SubTitle-->Column: TITEL
Icon and Badge-->Icon Source: Image URL
Image URL: &ICON.
Step:3
=====
Select Region Action then Create Action
Type: Full Card
Link-->Type: Redirect to URL
Target: &URL.