Einstein Analytics Pivot Table with Subtotals

  Рет қаралды 7,514

Carl Brundage

Carl Brundage

Күн бұрын

With a few easy steps, add subtotals and grand tables to a pivot table in Einstein Analytics

Пікірлер: 11
@pedroprada1
@pedroprada1 4 жыл бұрын
THanks Carl... great video... first time I see a Pivot table use case in EA
@muskieAA
@muskieAA 5 жыл бұрын
Thanks Carl! Awesome video
@carlbrundage1965
@carlbrundage1965 2 жыл бұрын
There's a new, even easier way to add column and row totals with Pivot tables in the Summer 22 release. See the updated video - kzfaq.info/get/bejne/qNldq8130JfHj4k.html
@user-wm1ut7sg6f
@user-wm1ut7sg6f 4 жыл бұрын
Great video Carl. I employed this technique on my dashboard but am having problems getting the Total to sort to the bottom. I tried renaming the field value to zTOTAL in the SAQL code then hoped to relabel in the XMD but the new value doesn't show up in the members list of values. How else could this be accomplished?
@pranavsharma3012
@pranavsharma3012 3 жыл бұрын
Hi Carl.. Nice video...But in my case when using sub totals then grouping of fields is not proper. Please suggest what should be done
@williamcollier3680
@williamcollier3680 5 жыл бұрын
Very interesting but as asked below, how to get this Please? Many thanks.
@carlbrundage1965
@carlbrundage1965 5 жыл бұрын
The SAQL would differ based on your specific dataset and fields. You can use the approach from the video to apply to your specific case.
@alexandermorenocamacho3175
@alexandermorenocamacho3175 4 жыл бұрын
Hello Carl, how can I change the color to the TOTAL text
@carlbrundage1965
@carlbrundage1965 4 жыл бұрын
Check out the Spring 20 release notes. There is now the ability to turn on/off grand total and sub totals. If you pick a style for the table, it will color the headers. releasenotes.docs.salesforce.com/en-us/spring20/release-notes/rn_bi_platform_totals.htm
@alexandermorenocamacho3175
@alexandermorenocamacho3175 4 жыл бұрын
@@carlbrundage1965 Thanks Carl, if I already checked them but it is not possible to put sub totals to the pivot tables
@user-wm1ut7sg6f
@user-wm1ut7sg6f 4 жыл бұрын
@@alexandermorenocamacho3175 I have the same problem since it's from a pivot table, the option to add totals and subtotals isn';t available.
Advanced Waterfalls with SAQL
5:51
Carl Brundage
Рет қаралды 603
Pivot Tables in Power BI !?
26:25
How to Power BI
Рет қаралды 39 М.
- А что в креме? - Это кАкАооо! #КондитерДети
00:24
Телеканал ПЯТНИЦА
Рет қаралды 7 МЛН
ТАМАЕВ УНИЧТОЖИЛ CLS ВЕНГАЛБИ! Конфликт с Ахмедом?!
25:37
How to Become a Data Analyst in 2023 (Completely FREE!)
13:59
Alex The Analyst
Рет қаралды 1 МЛН
GPT4o Mini - Lightning Fast, Dirty Cheap, Insane Quality (Tested)
13:20
Dealing with Incorrect Totals in Power BI
14:44
Goodly
Рет қаралды 45 М.
CRM Analytics Pivot Table with Subtotals for Columns and Rows
1:02
Carl Brundage
Рет қаралды 3,9 М.
Power Query made easy - learn the power of Quick Steps | Excel Off The Grid
10:57
Поел индийской еды...
0:15
Новостной Гусь
Рет қаралды 2,1 МЛН
Best Father #katebrush #shorts
0:17
Kate Brush
Рет қаралды 31 МЛН
My Hero Brother‼️ How to Survive Swimming Pool😎 Like a Boss💕❤️😘 | JJaiPan #Shorts
0:49
Love conquers all rules?
0:26
Den Do It
Рет қаралды 6 МЛН
Triggle #настольныеигры #boardgames #games #игры #настолки #настольные_игры
0:48
Двое играют | Наташа и Вова
Рет қаралды 9 МЛН
Waka waka #2 🤣 #shorts
0:15
Adani Family
Рет қаралды 28 МЛН
Очень ждал свою маму 💔
0:56
Awesome Cuts
Рет қаралды 7 МЛН