With a few easy steps, add subtotals and grand tables to a pivot table in Einstein Analytics
Пікірлер: 11
@pedroprada14 жыл бұрын
THanks Carl... great video... first time I see a Pivot table use case in EA
@muskieAA5 жыл бұрын
Thanks Carl! Awesome video
@carlbrundage19652 жыл бұрын
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-wm1ut7sg6f4 жыл бұрын
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?
@pranavsharma30123 жыл бұрын
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
@williamcollier36805 жыл бұрын
Very interesting but as asked below, how to get this Please? Many thanks.
@carlbrundage19655 жыл бұрын
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.
@alexandermorenocamacho31754 жыл бұрын
Hello Carl, how can I change the color to the TOTAL text
@carlbrundage19654 жыл бұрын
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
@alexandermorenocamacho31754 жыл бұрын
@@carlbrundage1965 Thanks Carl, if I already checked them but it is not possible to put sub totals to the pivot tables
@user-wm1ut7sg6f4 жыл бұрын
@@alexandermorenocamacho3175 I have the same problem since it's from a pivot table, the option to add totals and subtotals isn';t available.