Hi
how to get display grand total like below pivot
CREATE table input_table(First_Name,Last_Name,Country_Region,State) AS
SELECT 'Cameron' AS First_Name,'Greene' AS Last_Name,'India - East' AS Country_Region,'bihar' AS State FROM dual
UNION ALL
SELECT 'Dorothy','Clarkson','India - South','puducherry' FROM dual
UNION ALL
SELECT 'Kevin','Cornish','India - East','bihar' FROM dual
UNION ALL
SELECT 'Neil','Springer','India - West','gujarat' FROM dual
UNION ALL
SELECT 'Alison','Nash','India - West','gujarat' FROM dual
UNION ALL
SELECT 'Ian','Sutherland','India - North','delhi' FROM dual
UNION ALL
SELECT 'Diana','Thomson','India - East','bihar' FROM dual
UNION ALL
SELECT 'Gabrielle','Ross','India - South','puducherry' FROM dual
UNION ALL
SELECT 'Victor','Wright','India - East','bihar' FROM dual
UNION ALL
SELECT 'Neil','Young','India - West','gujarat' FROM dual
UNION ALL
SELECT 'Alexandra','Marshall','India - West','gujarat' FROM dual
UNION ALL
SELECT 'John','McLean','India - North','delhi' FROM dual
UNION ALL
SELECT 'Victor','Nash','India - East','bihar' FROM dual
UNION ALL
SELECT 'Alan','Piper','India - South','puducherry' FROM dual
UNION ALL
SELECT 'Amelia','Ross','India - East','bihar' FROM dual
UNION ALL
SELECT 'Ian','Pullman','India - West','gujarat' FROM dual
UNION ALL
SELECT 'Brandon','Berry','India - West','gujarat' FROM dual
UNION ALL
SELECT 'James','MacDonald','India - North','delhi' FROM dual
UNION ALL
SELECT 'Nicholas','Wallace','India - East','bihar' FROM dual
UNION ALL
SELECT 'Carolyn','Terry','India - South','puducherry' FROM dual
UNION ALL
SELECT 'Joan','Mathis','India - East','bihar' FROM dual
UNION ALL
SELECT 'Gavin','Peake','India - West','gujarat' FROM dual
UNION ALL
SELECT 'Victoria','Ince','India - West','gujarat' FROM dual
UNION ALL
SELECT 'Christopher','Underwood','India - North','delhi' FROM dual
UNION ALL
SELECT 'Stephanie','Oliver','India - North','delhi' FROM dual
UNION ALL
SELECT 'Tracey','James','India - East','bihar' FROM dual
UNION ALL
SELECT 'Sophie','Mackenzie','India - South','puducherry' FROM dual
UNION ALL
SELECT 'James','Knox','India - East','bihar' FROM dual
UNION ALL
SELECT 'Colin','Harris','India - West','gujarat' FROM dual
UNION ALL
SELECT 'Nathan','McLean','India - West','gujarat' FROM dual
UNION ALL
SELECT 'Nathan','Morrison','India - North','delhi' FROM dual
UNION ALL
SELECT 'Jack','North','India - East','bihar' FROM dual
UNION ALL
SELECT 'Anna','Walker','India - South','puducherry' FROM dual
UNION ALL
SELECT 'Natalie','Harris','India - East','bihar' FROM dual
UNION ALL
SELECT 'Piers','Greene','India - West','gujarat' FROM dual
UNION ALL
SELECT 'Bella','Butler','India - West','gujarat' FROM dual
UNION ALL
SELECT 'Faith','Reid','India - North','delhi' FROM dual
UNION ALL
SELECT 'Jacob','Parsons','India - East','bihar' FROM dual
UNION ALL
SELECT 'Alan','Bailey','India - South','puducherry' FROM dual
UNION ALL
SELECT 'Katherine','Ferguson','India - East','bihar' FROM dual;
expected output
Thanks!