subtotal in a Pivot table

[mario-sarkis]

Hey ,

any Idea if i dont want to show the subtotal in a pivot table how can i do it ?

[sunny_talwar · Accepted solution]

Uncheck 'Show Partial Sum' for all your dimension on the presentation tab:

[PrashantSangle]

Hi,

Go to presentation tab-> select Dimension->unselect Show Partial Sum

Regards

[mario-sarkis]

Hi Sunny sunindia, i have a question for you i have this following expression my requirement is to ignore all selection execet several fields as shown

=(sum({    1

            <                 [RM User]=$::[RM User]       

                              ,[BRANCH]=$::[BRANCH]       

                              ,[RM Full Name]=$::[RM Full Name]       

                              ,[RM  Party]={1}       

                              ,[RM Product/GL]={'Product'}       

                              ,Date={'$(=Date(Max(DateFinance),'M/D/YYYY'))'}                                   

                      >     

                               }  Balance))

but the problem is the selection on for example YEAR and Month still effect the expression when i comment the date field in the expression they will not effect it  as shown:

=(sum({    1

            <                 [RM User]=$::[RM User]       

                              ,[BRANCH]=$::[BRANCH]       

                              ,[RM Full Name]=$::[RM Full Name]       

                              ,[RM  Party]={1}       

                              ,[RM Product/GL]={'Product'}       

                         //     ,Date={'$(=Date(Max(DateFinance),'M/D/YYYY'))'}                                   

                      >     

                               }  Balance))

But i need this condition in order to get the right value.

Can you help me ?

[sunny_talwar]

What is your chart's dimension where you are using the above expression?

[mario-sarkis]

sunindia well i need to show is in a  text object  This Expression >>

=num((sum({1<[BRANCH]=$::[BRANCH],[RM Full Name]=$::[RM Full Name],DateFinance=,[RM Year]=,[RM Month]=,[RM FinalFinance Party]={1},[RM Finance Product/GL]={'Product'},DateFinance={"$(=Date(Max(DateFinance),'M/D/YYYY'))"}>}FinanceBalance))
-
(sum({1<[BRANCH]=$::[BRANCH],[RM Full Name]=$::[RM Full Name],DateFinance=,[RM Year]=,[RM Month]=,[RM FinalFinance Party]={1},[RM Finance Product/GL]={'Product'},DateFinance={"$(=Date(Max({1}{<DateFinance={'<$(=Date(Max(DateFinance),'M/D/YYYY'))'}>}DateFinance),'M/D/YYYY'))"}>}FinanceBalance)),'#,##0')

but the selection still effect it i think i should add something to the "DateFinance " here in this expression to do not change once i selet on a Year or Month field. Hope u can help.