logo
Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error

Options
Go to last post Go to first unread
Sujeet Kumar T  
#1 Posted : Thursday, September 5, 2019 1:40:04 PM(UTC)
Sujeet Kumar T

Rank: Newbie

Groups: Registered
Joined: 8/12/2019(UTC)
Posts: 3
India
Location: Hyderabad

Hi All,

I am unable to get subtotals on TOP in single row, can anyone suggest me on this.

RAW DATA:

ID|| MASTER GROUP NAME || GROUP NAME || LINE || BALANCE||
--------------------------------------------------------------------------------------------------------------------||
1 ||TOTAL LOANS and ADVANCES (sum 2-4)||1 TOTAL LOANS and ADVANCES (sum 2-2.5) || || 15 ||
2 ||SHORT TERM (sum 2.1-2.13) || ||2.1 Int trade || 1 ||
2 ||SHORT TERM (sum 2.1-2.13) ||2.4 International trade (sum 2.4.1-2.4.2) ||2.2 Export || 2 ||
2 ||SHORT TERM (sum 2.1-2.13) ||2.4 International trade (sum 2.4.1-2.4.2) ||2.3 Import || 3 ||
2 ||SHORT TERM (sum 2.1-2.13) ||2.5 Building and construction (sum 2.4.1-2.4.4)||2.4 TRADE || 4 ||
2 ||SHORT TERM (sum 2.1-2.13) ||2.5 Building and construction (sum 2.5.1-2.5.4)||2.5 Commercial || 5 ||


EXPECTED OUTPUT:

ID|| MASTER GROUP NAME || BALANCE ||

1 ||TOTAL LOANS and ADVANCES (sum 2-4)|| 15 ||
2 ||SHORT TERM (sum 2.1-2.5 ) || 1 ||
3 ||2.1 Agriculture || 2 ||
4 ||2.2 Manufacturing || 3 ||
5 ||2.3 Domestic trade || 4 ||
6 ||2.4 Int trade (sum 2.4.1-2.4.2)|| 5 ||
7 ||2.4.1 Export || ||
8 ||2.4.2 Import || ||
9 ||2.5 Hotel & tourism || ||

As this is the requirement from client, expecting a quick reply.

Thanks & Regards,
Sujeet


















epf  
#2 Posted : Monday, September 9, 2019 6:25:38 AM(UTC)
epf

Rank: Administration

Groups: Administrators
Joined: 12/20/2013(UTC)
Posts: 693
Switzerland

Thanks: 12 times
Was thanked: 126 time(s) in 123 post(s)
Hi, your sample is not very clear, can you do it with Northwind ?
Sujeet Kumar T  
#3 Posted : Friday, September 13, 2019 5:29:23 AM(UTC)
Sujeet Kumar T

Rank: Newbie

Groups: Registered
Joined: 8/12/2019(UTC)
Posts: 3
India
Location: Hyderabad

In below link we have uploaded my output image.

https://ibb.co/KLs1sDJ

Thanks
Sujeet

Edited by user Friday, September 13, 2019 9:09:15 AM(UTC)  | Reason: Not specified

Users browsing this topic
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.