Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Community,
I have one requirement.. in Pivot table or Straight table
Example:
I have Month wise data.. but i want to split first 3 months, 6 months and Last 3 months.
This is my data in Pivot table, working perfect.
but my requirement i want to show empty line for group level..
Hope you understand..
Thanks in Advance..
PFA,
May be like this:
Add a new Inline table like this:
LOAD Month(Date#(Month, 'MMM')) as Month,
Group
Inline [
Month, Group
Jan, 1
Feb, 1
Mar, 1
Apr, 2
May, 2
Jun, 2
Jul, 2
Aug, 2
Sep, 2
Oct, 3
Nov, 3
Dec, 3
];
And use Group as the very first dimension in the chart
Thanks sunny..
Can we show like..
After one group, i want to show one empty line..
Like this?
change your master Calendar to and add another dimension
if (Month >= 1 and Month <= 3,'G1',if(Month > 3 and Month <= 6,'G2','G3')) as MonthGroup
make a pivot table and add these dimensions
MonthGroup
Month
make you expression as sum of sale
The Pivot table will be close of what you are looking for
But, The empty line i want to standardized for each group.
If make selection also i want to show empty line.
HI sunny,
Is this possible??
I will need to do some testing. I will get back with my findings. Sorry for the delay