Great Video Sir! Is there a way to have measure labels appear as rows? I did not find anything in this regards. Let's say on columns you have market codes, for each market codes you have a bunch of measures. On the rows i would like to shows : Number of rooms, number of guests, room revenue, food revenue, total revenue. For each market code i would like to see these values
Unfortunately, I'm not sure that BI Pub can work with that multi-dimension data in a pivot grid. You would be working with multiple numbers in the grid representing different items that you would not want analyzed together. Ie: you wouldn't want to sum rooms and guests together. It would be fun to try. You would have your market as a key, and the rooms, guests and different revenues as different fields in that data row. Then drag all those data rows into the grid.
Can you do a pivot table in BI Publisher rtf template without aggregation? In Excel, I can choose Max value instead of couting or summing I have several Six categories that each represent a set time frame (Ex. Summer2, Fall, Winter, Spring, Summer1), There are several groups and within each group for each timeframe, there are several item codes. Each of those items could cost a flat amount or an amount per unit. I want a pivot table showing the items down the left with the timeframes across the top. In the section that would normally be aggregated, I want the exact amount associated with the item code. Can this be done in BI Publisher?
I've been thinking about this one. The best idea I can think of is to pre-massage your data so that only one entry per category is found for the pivot table and use summation (not count).
Thanks for this video, can you share how to get the data or data model for this case?
Here is a link to the Github with the data set and rtf templates for the pivot grid demo
github.com/PeopleToolsTechTips/PT3_E030_BI-Pub-PIvot-Grids
Great Video Sir! Is there a way to have measure labels appear as rows? I did not find anything in this regards. Let's say on columns you have market codes, for each market codes you have a bunch of measures. On the rows i would like to shows : Number of rooms, number of guests, room revenue, food revenue, total revenue. For each market code i would like to see these values
Unfortunately, I'm not sure that BI Pub can work with that multi-dimension data in a pivot grid. You would be working with multiple numbers in the grid representing different items that you would not want analyzed together. Ie: you wouldn't want to sum rooms and guests together.
It would be fun to try. You would have your market as a key, and the rooms, guests and different revenues as different fields in that data row. Then drag all those data rows into the grid.
Can I have in the pivot table a total field with the rows average instaead of sum?
Unfortunately, the aggregations are only SUM and COUNT.
Not Average
Can you do a pivot table in BI Publisher rtf template without aggregation? In Excel, I can choose Max value instead of couting or summing I have several Six categories that each represent a set time frame (Ex. Summer2, Fall, Winter, Spring, Summer1), There are several groups and within each group for each timeframe, there are several item codes. Each of those items could cost a flat amount or an amount per unit. I want a pivot table showing the items down the left with the timeframes across the top. In the section that would normally be aggregated, I want the exact amount associated with the item code. Can this be done in BI Publisher?
I've been thinking about this one. The best idea I can think of is to pre-massage your data so that only one entry per category is found for the pivot table and use summation (not count).